Information functions

Information Functions

FUNCTIONS

[[{{{PrevPage}}}|< Previous Page

]]

[[{{{NextPage}}}|Next Page

>]]

Information Functions

The information functions return information about cell contents.

CELL	Returns information about the address, formatting or contents of a cell
CURRENT	Returns the current (to date) result of evaluating the formula.
FORMULA	Returns the formula used in a cell as a text string.
ISBLANK	Tests if the cell is blank (empty).
ISERR	Tests for an error value other than #N/A (Not Available).
ISERROR	Tests for any error value.
ISEVEN	Tests for even numbers.
ISEVEN_ADD	Returns 1 if the value is an even number, or 0 if the value is odd.
ISFORMULA	Tests if a cell contains a formula.
ISLOGICAL	Tests if a cell contains a logical value, TRUE or FALSE.
ISNA	Tests if a cell contains the #N/A (Not Available) error value.
ISNONTEXT	Tests if a cell contains non-text.
ISNUMBER	Tests if a cell contains a number.
ISODD	Tests for odd numbers.
ISODD_ADD	Returns 1 if the value is an odd number, or 0 if the value is even.
ISREF	Tests if the argument is a reference to a cell or range of cells.
ISTEXT	Tests if a cell contains text.
N	Returns the numeric value.
NA	Returns the #N/A (Not Available) error value .
TYPE	Returns the type of value (number, text, etc.).

See Also