# Documentation/Calc Functions/ISNA

Other languages:

ISNA

Information

## Summary:

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

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.

• 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

ISNA