﻿ Information Functions | SpreadJS 14
Formula Reference / Formula Functions / Information Functions
In This Topic
Information Functions
In This Topic

Spread provides the following information functions, listed alphabetically.

Function Description
ERROR.TYPE This function returns a number corresponding to one of the error values.
ISBLANK This function tests whether a value, an expression, or contents of a referenced cell is empty.
ISERR This function, Is Error Other Than Not Available, tests whether a value, an expression, or contents of a referenced cell has an error other than not available (#N/A).
ISERROR This function, Is Error of Any Kind, tests whether a value, an expression, or contents of a referenced cell has an error of any kind.
ISEVEN This function, Is Number Even, tests whether a value, an expression, or contents of a referenced cell is even.
ISFORMULA This function tests whether contains a formula of a referenced cell.
ISLOGICAL This function tests whether a value, an expression, or contents of a referenced cell is a logical (Boolean) value.
ISNA This function, Is Not Available, tests whether a value, an expression, or contents of a referenced cell has the not available (#N/A) error value.
ISNONTEXT This function tests whether a value, an expression, or contents of a referenced cell has any data type other than text.
ISNUMBER This function tests whether a value, an expression, or contents of a referenced cell has numeric data.
ISODD This function, Is Number Odd, tests whether a value, an expression, or contents of a referenced cell has numeric data.
ISREF This function, Is Reference, tests whether a value, an expression, or contents of a referenced cell is a reference to another cell.
ISTEXT This function tests whether a value, an expression, or contents of a referenced cell has text data.
N This function returns a value converted to a number.
NA This function returns the error value #N/A that means not available.
TYPE This function returns the type of value.