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
ﬁ 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 ﬁ rst calculates
the formula in the value argument. If that formula does not evaluate to an error,
calculation stops and the result of the ﬁ 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 coefﬁ 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