| IF | The value based on a condition you specify. |
| IMABS* | The absolute value (modulus) of a complex number. |
| IMAGINARY* | The imaginary coefficient of a complex number. |
| IMARGUMENT* | The theta argument (an angle in radians). |
| IMCONJUGATE* | The complex conjugate of a complex number. |
| IMCOS* | The cosine 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. |
| IMSIN* | The 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. |
| INDEX | The value from a table, based on an index number. |
| 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 fully invested security. |
| IPMT | The interest payment for a given period of an investment. |
| IRR | The internal rate of return for a series of cash flows. |
| ISBLANK | The boolean value depending if the value is blank. |
| ISERR | The boolean value depending if the value is an error (not N/A). |
| ISERROR | The boolean value depending if the value is an error. |
| ISEVEN* | The boolean value depending if the value is an even number. |
| ISLOGICAL | The boolean value depending if the value is True or False. |
| ISNA | The boolean value depending if the value is N/A. |
| ISNONTEXT | The boolean value depending if the value is non text. |
| ISNUMBER | The boolean value depending if the value is a number. |
| ISODD* | The boolean value depending if the value is an odd number. |
| ISPMT | The interest paid during a specific period of an investment. |
| ISREF | The boolean value depending if the value is a cell reference. |
| ISTEXT | The boolean value depending if the value is text. |