# Documentation/Calc Functions/ISNA

Jump to navigation
Jump to search

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:

## Equivalent Excel functions:

ISNA