<< 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