<< Click to Display Table of Contents >> ISNA (is not available?)

Syntax:

ISNA(Cell)

Description:

This returns TRUE if the given 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.

For more information on the usage of #N/A error values, see the description of the NA (error value #N/A) function.

Example:

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

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

Thus, the following applies:

ISNA(A1) returns TRUE

ISNA(C7) also returns TRUE

See also:

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