Information

Class Library 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.