Spread Formula Reference
Formula Functions / Functions H to L / ISNA
In This Topic
    ISNA
    In This Topic

    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.

    Syntax

    ISNA(cellreference)

    ISNA(value)

    ISNA(expression)

    Arguments

    Specify a cell reference, a numeric or text value, or an expression for the argument.

    Remarks

    Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.

    This function returns TRUE if the value is or refers to the Not Available error value, and returns FALSE if the value is or refers to a cell with no data.

    Data Types

    Accepts any data type for an argument. Returns Boolean (TRUE or FALSE) data.

    Examples

    ISNA(B12)

    ISNA(R12C2)

    ISNA(#N/A)gives the result TRUE

    ISNA(NA())gives the result TRUE

    ISNA(#REF)gives the result FALSE

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    ERRORTYPE | ISERR | ISERROR | NA | Information Functions