Documentation/Calc Functions/ISNA

Function name:
ISNA

Category:
Information

Summary:
Determines if a specified cell or expression evaluates to the #N/A (value not available) error value.

Syntax:
ISNA(Value)

Returns:
Returns TRUE if the argument evaluates to the #N/A (value not available) error and returns FALSE otherwise.

Arguments:
Value is an expression, or a reference to a cell containing an expression, that is to be tested for the #N/A error condition.

Additional details:

 * ISNA does not propagate errors. If Value evaluates to a #N/A error, then ISNA returns TRUE and returns FALSE otherwise.

Related LibreOffice functions:
ERROR.TYPE

ISERR

ISERROR

ISNUMBER

ISTEXT

NA

ODF standard:
Section 6.13.20, part 2

Equivalent Excel functions:
ISNA