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 coeffi 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 specifi 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
fl 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:
 
Search JabSto ::




Custom Search