Documentation/Calc Functions/ISNA

    From The Document Foundation Wiki
    Other languages:


    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

    Related (or similar) Excel functions:

    ISNA