Documentation/Calc Functions/ISNA

From The Document Foundation Wiki
Jump to navigation Jump to search
Other languages:
English • ‎Nederlands • ‎italiano



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:

ERROR.TYPE

ISERR

ISERROR

ISNUMBER

ISTEXT

NA

ODF standard:

Section 6.13.20, part 2

Equivalent Excel functions:

ISNA