Documentation/Calc Functions/ISERROR

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.

Related LibreOffice functions:
ERROR.TYPE

ISERR

ISNA

ISNUMBER

ISTEXT

NA

ODF standard:
Section 6.13.16, part 2

Equivalent Excel functions:
ISERROR