Alphabetical - I

IFThe value based on a condition you specify.
IFERRORThe value based on an error condition you specify.
IFNA(2013) The value True or False depending if the value is #N/A.
IFS(2016) The value based on multiple conditions you specify.
IMABSThe absolute value of a complex number.
IMAGINARYThe imaginary coefficient of a complex number.
IMARGUMENTThe theta argument in radians.
IMCONJUGATEThe complex conjugate of a complex number.
IMCOSThe cosine of a complex number.
IMCOSH(2013) The hyperbolic cosine of a complex number.
IMCOT(2013) The cotangent of a complex number.
IMCSC(2013) The cosecant of a complex number.
IMCSCH(2013) The hyperbolic cosecant of a complex number.
IMDIVThe quotient of two complex numbers.
IMEXPThe exponential of a complex number.
IMLNThe natural logarithm of a complex number.
IMLOG10The base-10 logarithm of a complex number.
IMLOG2The base-2 logarithm of a complex number.
IMPOWERThe complex number raised to an integer number.
IMPRODUCTThe product of two or more complex numbers.
IMREALThe real coefficient of a complex number.
IMSEC(2013) The secant of a complex number.
IMSECH(2013) The hyperbolic secant of a complex number.
IMSINThe sine of a complex number.
IMSINH(2013) The hyperbolic sine of a complex number.
IMSQRTThe square root of a complex number.
IMSUBThe difference of two complex numbers.
IMSUMThe sum of two or more complex numbers.
IMTAN(2013) The tangent of a complex number.
INDEXThe value from a cell range which is the intersection of a row AND a column.
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.
INTRATEThe interest rate for a security held to maturity.
IPMTThe interest paid for a given period in a series of equal cash flows at regular intervals.
IRRThe interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
ISBLANKThe value True or False depending if the value is blank.
ISERRThe value True or False depending if the value is an error (not #N/A).
ISERRORThe value True or False depending if the value is an error.
ISEVENThe value True or False depending if the value is an even number.
ISFORMULA(2013) The value True or False depending if the cell contains a formula.
ISLOGICALThe value True or False depending if the value is True or False.
ISNAThe value True or False depending if the value is #N/A.
ISNONTEXTThe value True or False depending if the value is non text.
ISNUMBERThe value True or False depending if the value is a number.
ISO.CEILING(CELING.MATH) The number rounded up to the nearest integer or significant figure (renamed).
ISODDThe value True or False depending if the value is an odd number.
ISOWEEKNUM(2013) The number of the ISO week of the year for a given date.
ISPMT(IPMT) The interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly).
ISREFThe value True or False depending if the value is a cell reference.
ISTEXTThe value True or False depending if the value is text.
IF
The value based on a condition you specify.
IFERROR
The value based on an error condition you specify.
IFNA
(2013) The value True or False depending if the value is #N/A.
IFS
(2016) The value based on multiple conditions you specify.
IMABS
The absolute value of a complex number.
IMAGINARY
The imaginary coefficient of a complex number.
IMARGUMENT
The theta argument in radians.
IMCONJUGATE
The complex conjugate of a complex number.
IMCOS
The cosine of a complex number.
IMCOSH
(2013) The hyperbolic cosine of a complex number.
IMCOT
(2013) The cotangent of a complex number.
IMCSC
(2013) The cosecant of a complex number.
IMCSCH
(2013) The hyperbolic cosecant 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.
IMSEC
(2013) The secant of a complex number.
IMSECH
(2013) The hyperbolic secant of a complex number.
IMSIN
The sine of a complex number.
IMSINH
(2013) The hyperbolic 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.
IMTAN
(2013) The tangent of a complex number.
INDEX
The value from a cell range which is the intersection of a row AND a column.
INDIRECT
The text string of the contents of a given cell reference.
INFO
The text string returning useful information about the environment.
INT
The number rounded down to the nearest integer.
INTERCEPT
The intersection with the y-axis using a linear regression plotted through known values.
INTRATE
The interest rate for a security held to maturity.
IPMT
The interest paid for a given period in a series of equal cash flows at regular intervals.
IRR
The interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
ISBLANK
The value True or False depending if the value is blank.
ISERR
The value True or False depending if the value is an error (not #N/A).
ISERROR
The value True or False depending if the value is an error.
ISEVEN
The value True or False depending if the value is an even number.
ISFORMULA
(2013) The value True or False depending if the cell contains a formula.
ISLOGICAL
The value True or False depending if the value is True or False.
ISNA
The value True or False depending if the value is #N/A.
ISNONTEXT
The value True or False depending if the value is non text.
ISNUMBER
The value True or False depending if the value is a number.
ISO.CEILING
(CELING.MATH) The number rounded up to the nearest integer or significant figure (renamed).
ISODD
The value True or False depending if the value is an odd number.
ISOWEEKNUM
(2013) The number of the ISO week of the year for a given date.
ISPMT
(IPMT) The interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly).
ISREF
The value True or False depending if the value is a cell reference.
ISTEXT
The value True or False depending if the value is text.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top