To get detailed information about a function, click its name in the first column.
Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.
Function |
Description |
---|---|
Returns information about the formatting, location, or contents of a cell Note: This function is not available in Excel for the web. |
|
Returns a number corresponding to an error type |
|
Returns information about the current operating environment Note: This function is not available in Excel for the web. |
|
Returns TRUE if the value is blank |
|
Returns TRUE if the value is any error value except #N/A |
|
Returns TRUE if the value is any error value |
|
Returns TRUE if the number is even |
|
Returns TRUE if there is a reference to a cell that contains a formula |
|
Returns TRUE if the value is a logical value |
|
Returns TRUE if the value is the #N/A error value |
|
Returns TRUE if the value is not text |
|
Returns TRUE if the value is a number |
|
Returns TRUE if the number is odd |
|
Checks whether the value in a LAMBDA is missing and returns TRUE or FALSE |
|
Returns TRUE if the value is a reference |
|
Returns TRUE if the value is text |
|
Returns a value converted to a number |
|
Returns the error value #N/A |
|
Returns the sheet number of the referenced sheet |
|
Returns the number of sheets in a reference |
|
Returns a number indicating the data type of a value |
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.