Navigation:  Formula Reference > Spreadsheet Formula Functions >

ISNA

Previous pageReturn to chapter overviewNext page

 

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

 

See Also

ERROR.TYPE

ISERR

ISERROR