ISNA (is not available?)

<< Click to Display Table of Contents >>

ISNA (is not available?)

Syntax:

ISNA(Reference)

Description:

Returns TRUE if the specified cell contains a #N/A error value.

Cells contain a #N/A error value if they contain the formula =NA(), or a calculation resulting in a #N/A error.

More details about the usage of #N/A error values can be found in section NA (error value #N/A).

Example:

The function NV() was entered in cell A1 to indicate that a value is not yet available that is absolutely necessary for another calculation.

Cell C7 performs a calculation with cell A1, for example A1*2. But since cell A1 returns the error value #N/A, the result of this calculation is also the error value #N/A.

Therefore, the following applies:

ISNA(A1) returns TRUE

ISNA(C7) also returns TRUE

See also:

NA(), ERROR.TYPE, ISERR, ISERROR, IFERROR, IFNA, section Error values