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. |
| 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. |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top