Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > I< Previous | Next > 

 ABCDEFGH

I

JKLMNOPQRSTUVWXYZ 
 
IFThe value based on a condition you specify.
IMABS*The absolute value (modulus) of a complex number.
IMAGINARY*The imaginary coefficient of a complex number.
IMARGUMENT*The theta argument (an angle in radians).
IMCONJUGATE*The complex conjugate of a complex number.
IMCOS*The cosine of a complex number.
IMDIV*The quotient of two complex numbers.
IMEXP*The exponential of a complex number.
IMLN*The natural logarithm of a complex number.
IMLOG10*The base-10 logarithm of a complex number.
IMLOG2*The base-2 logarithm of a complex number.
IMPOWER*The complex number raised to an integer number.
IMPRODUCT*The product of two or more complex numbers.
IMREAL*The real coefficient of a complex number.
IMSIN*The sine of a complex number.
IMSQRT*The square root of a complex number.
IMSUB*The difference of two complex numbers.
IMSUM*The sum of two or more complex numbers.
INDEXThe value from a table, based on an index number.
INDIRECTThe text string of the contents of a given cell reference.
INFOThe text string returning useful information about the environment.
INTThe number rounded down to the nearest integer.
INTERCEPTThe intersection with the y-axis using a linear regression plotted through known values.
INTRATE*The interest rate for a fully invested security.
IPMTThe interest payment for a given period of an investment.
IRRThe internal rate of return for a series of cash flows.
ISBLANKThe boolean value depending if the value is blank.
ISERRThe boolean value depending if the value is an error (not N/A).
ISERRORThe boolean value depending if the value is an error.
ISEVEN*The boolean value depending if the value is an even number.
ISLOGICALThe boolean value depending if the value is True or False.
ISNAThe boolean value depending if the value is N/A.
ISNONTEXTThe boolean value depending if the value is non text.
ISNUMBERThe boolean value depending if the value is a number.
ISODD*The boolean value depending if the value is an odd number.
ISPMTThe interest paid during a specific period of an investment.
ISREFThe boolean value depending if the value is a cell reference.
ISTEXTThe boolean value depending if the value is text.
 
 Note: * These are Analysis ToolPak functions

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top