Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

IMPOWER(inumber,number) [Category: Engineering]*

Returns a complex number in x + yi or x + yj text format raised to a power.

IMPRODUCT(inumber1,inumber2,...) [Category: Engineering]*

Returns the product of 2 to 29 complex numbers in x + yi or x + yj text format.

IMREAL(inumber) [Category: Engineering]*

Returns the real coefﬁ cient of a complex number in x + yi or x + yj text format.

IMSIN(inumber) [Category: Engineering]*

Returns the sine of a complex number in x + yi or x + yj text format.

IMSQRT(inumber) [Category: Engineering]*

Returns the square root of a complex number in x + yi or x + yj text format.

IMSUB(inumber1,inumber2) [Category: Engineering]*

Returns the difference of two complex numbers in x + yi or x + yj text format.

IMSUM(inumber1,inumber2,...) [Category: Engineering]*

Returns the sum of two or more complex numbers in x + yi or x + yj text

format.

INDEX(array,row_num,column_num) [Category: Lookup & Reference]

Returns the value of a speciﬁ ed cell or array of cells within array. Guru Tip:

INDEX is often paired with the MATCH function to do a lookup which is more

ﬂ exible than VLOOKUP (see page 54 for an example). Column_num is optional

if you have only a single column of data in the array. If you want to select a

random item from J1:J20, use =INDEX($J$1:$J$20,RANDBETWEEN(1,20)).

To turn a range on its side, use INDEX and ROW as shown below: