Documentation/Calc Functions/ISERROR

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



Function name:

ISERROR

Category:

Information

Summary:

Determines if a specified cell or expression evaluates to an error type.

In contrast to Calc’s ISERR function, ISERROR returns TRUE if the argument evaluates to the value not available error (#N/A).

Syntax:

ISERROR(Value)

Returns:

Returns TRUE if the argument evaluates to an 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 an error condition.

Additional details:

  • ISERROR does not propagate errors. If Value evaluates to an error then ISERROR returns TRUE and returns FALSE otherwise.
  • Use the ISERR function to test for errors if you do not wish to include #N/A as an error condition.
  • Use ISERROR in conjunction with the IF function to test for errors and take different actions in normal and error conditions.

Examples:

Formula Description Returns
=ISERROR(12.34) Here the function returns the logical value FALSE. FALSE
=ISERROR("Hello world!") Here the function returns the logical value FALSE. FALSE
=ISERROR(TRUE()) Here the function returns the logical value FALSE. FALSE
=ISERROR(2021-12-18) Here the function returns the logical value FALSE. FALSE
=ISERROR(D1) where cell D1 contains the formula =1/0. Here cell D1 contains a #DIV/0! error and so the function returns the logical value TRUE. TRUE
=ISERROR(D2) where cell D2 contains the formula =SQRT(-7). Here cell D2 contains an invalid argument error (Err:502) and so the function returns the logical value TRUE. TRUE
=ISERROR(D3) where cell D3 contains the formula =NA(). Here cell D3 contains a #N/A error and so the function returns the logical value TRUE. TRUE

Related LibreOffice functions:

ERROR.TYPE

ISERR

ISNA

ISNUMBER

ISTEXT

NA

ODF standard:

Section 6.13.16, part 2

Equivalent Excel functions:

ISERROR