Alphabetical - I

IFThe value based on whether a condition is True or False.
IFERRORThe value or something else if it evaluates to an error.
IFNA(2013) The value or something else if it evaluates to #N/A.
IFS(2019) The value based on multiple True or False conditions.
IMABSThe absolute value of a complex number.
IMAGE(Microsoft 365) The image from a web URL.
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 value of a given cell reference specified by a text string.
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 amount paid on a given period on a loan with fixed interest.
IRRThe interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
ISBLANKThe boolean True or False depending if the value is blank.
ISERRThe boolean True or False depending if the value is an error (not #N/A).
ISERRORThe boolean True or False depending if the value is an error.
ISEVENThe boolean True or False depending if the value is an even number.
ISFORMULA(2013) The boolean True or False depending if the cell contains a formula.
ISLOGICALThe boolean True or False depending if the value is True or False.
ISNAThe boolean True or False depending if the value is #N/A.
ISNONTEXTThe boolean True or False depending if the value is non text.
ISNUMBERThe boolean 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 boolean True or False depending if the value is an odd number.
ISOMITTED(Microsoft 365) The boolean True or False depending whether the value in a LAMBDA is missing.
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 boolean True or False depending if the value is a cell reference.
ISTEXTThe boolean True or False depending if the value is text.
IF
The value based on whether a condition is True or False.
IFERROR
The value or something else if it evaluates to an error.
IFNA
(2013) The value or something else if it evaluates to #N/A.
IFS
(2019) The value based on multiple True or False conditions.
IMABS
The absolute value of a complex number.
IMAGE
(Microsoft 365) The image from a web URL.
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 value of a given cell reference specified by a text string.
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 amount paid on a given period on a loan with fixed interest.
IRR
The interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
ISBLANK
The boolean True or False depending if the value is blank.
ISERR
The boolean True or False depending if the value is an error (not #N/A).
ISERROR
The boolean True or False depending if the value is an error.
ISEVEN
The boolean True or False depending if the value is an even number.
ISFORMULA
(2013) The boolean True or False depending if the cell contains a formula.
ISLOGICAL
The boolean True or False depending if the value is True or False.
ISNA
The boolean True or False depending if the value is #N/A.
ISNONTEXT
The boolean True or False depending if the value is non text.
ISNUMBER
The boolean 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 boolean True or False depending if the value is an odd number.
ISOMITTED
(Microsoft 365) The boolean True or False depending whether the value in a LAMBDA is missing.
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 boolean True or False depending if the value is a cell reference.
ISTEXT
The boolean True or False depending if the value is text.

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