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.