# Alphabetical - I

 IFThe value based on whether a certain condition is True or False. IFERRORThe value or something else if it evaluates to an error. IFNA(2013) The value True or False depending if the value is #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 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 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 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. ISOMITTED(Microsoft 365) The value 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 value True or False depending if the value is a cell reference. ISTEXTThe value True or False depending if the value is text.