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.