Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
worksheet calculation. Many gurus routinely have their spreadsheets calculate
every VLOOKUP twice with =IF(ISNA(VLOOKUP(A2,MyTable,2,False)),0, VLO
OKUP(A2,MyTable,2,False)). The problem with this long formula is that Excel
fi rst does the VLOOKUP to see if the result is #N/A. If the result is not #N/A, the
formula then makes Excel do the VLOOKUP a second time to use the result in
the value_if_false portion of the formula. If you are doing this in 500,000 cells,
calculation time will slow dramatically. The IFERROR function fi rst calculates
the formula in the value argument. If that formula does not evaluate to an error,
calculation stops and the result of the fi rst argument is used in the cell. If the
calculation results in any error such as #N/A or #DIV/0, the function will use the
2nd argument instead. This means that time-consuming calculations only have
to be performed once per cell. =IFERROR(VLOOKUP(A2,Table,2,False),0).
IMABS(inumber) [Category: Engineering]*
Returns the absolute value (modulus) of a complex number in x + yi or x + yj
text format.
IMAGINARY(inumber) [Category: Engineering]*
Returns the imaginary coeffi cient of a complex number in x + yi or x + yj text
format.
IMARGUMENT(inumber) [Category: Engineering]*
Returns the argument
(theta) an angle expressed in radians, such that:
IMCONJUGATE(inumber) [Category: Engineering]*
Returns the complex conjugate of a complex number in x + yi or x + yj text
format.
IMCOS(inumber) [Category: Engineering]*
Returns the cosine of a complex number in x + yi or x + yj text format.
IMDIV(inumber1,inumber2) [Category: Engineering]*
Returns the quotient of two complex numbers in x + yi or x + yj text format.
IMEXP(inumber) [Category: Engineering]*
Returns the exponential of a complex number in x + yi or x + yj text format.
IMLN(inumber) [Category: Engineering]*
Returns the natural logarithm of a complex number in x + yi or x + yj text
format.
IMLOG10(inumber) [Category: Engineering]*
Returns the common logarithm (base 10) of a complex number in x + yi or x +
yj text format.
IMLOG2(inumber) [Category: Engineering]*
Returns the base-2 logarithm of a complex number in x + yi or x + yj text
format.
 
Search JabSto ::




Custom Search