Programmming Overview > Supported Formula Functions
For further informations about argument types, restrictions and return values please see Office Open XML File Formats - ISO/IEC 29500 - 1, Chapter: 18.17.7 Predefined Function Definitions.
Formula | 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. |