Information
Information functions test what a value or a table cell holds: whether it is empty, a number, text or a logical value, whether a number is even or odd and whether a value is a cell reference. Others convert a value to a number, return its type or return the error value #N/A.
Argument types, restrictions and return values of each function are defined in Office Open XML File Formats, ISO/IEC 29500-1, chapter 18.17.7 Predefined Function Definitions.
Information Functions
| Function | Description |
|---|---|
ISBLANK(value) | Determines if value refers to an empty cell. |
ISEVEN(value) | Determines if value is an even number or refers to a cell containing an even number. |
ISLOGICAL(value) | Determines if value contains a logical value or refers to a cell containing a logical value. |
ISNONTEXT(value) | Determines if value does not contain text or does not refer to a cell containing text. An empty cell is not text. |
ISNUMBER(value) | Determines if value contains a number or refers to a cell that contains a number. |
ISODD(value) | Determines if value is an odd number or refers to a cell containing an odd number. |
ISREF(value) | Determines if value is a cell reference. |
ISTEXT(value) | Determines if value contains text or refers to a cell containing text. |
N(value) | Converts value to a number or, if value is a reference to a single cell, converts the value of that cell to a number. |
NA() | Gets the error value #N/A. (The error value #N/A can be used instead of a call to this function; the result is the same.) |
TYPE(value) | Computes the type of value or, if value is a reference to a single cell, the type of the value in that cell. |