# Alphabetical - I

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. |

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. |

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