Documentation/Calc Functions/ISNA
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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.
Examples:
| Formula | Description | Returns |
|---|---|---|
| =ISNA(SQRT(−2)) | Here the function returns FALSE because, although the argument to ISNA generates an invalid argument error (Err:502), it is not the #N/A error. | FALSE |
=ISNA(D1) where cell D1 contains the formula =NA(). |
Here the function returns the logical value TRUE because cell D1 contains the value returned by the NA function, which is the #N/A error. | TRUE |
| =ISNA("LibreOffice Calc") | Here the function returns FALSE because the argument is a string, not an error. | FALSE |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
ISNA