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