Spread Formula Reference
ISNA
Formula Functions > Functions H to L > 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.

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