Documentation/Calc Functions/ISERR

Function name:
ISERR

Category:
Information

Summary:
Determines if a specified cell or expression evaluates to an error type other than #N/A.

Syntax:
ISERR(Value)

Returns:
Returns TRUE if the argument evaluates to an error value other than the value not available error (#N/A) 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 (other than #N/A).

Additional details:

 * ISERR does not propagate errors. If Value evaluates to an error other than #N/A, then ISERR returns TRUE. If Value evaluates to a #N/A error, then ISERR returns FALSE.


 * Use the ISERROR function to test for any errors including #N/A. The formula  is equivalent to the formula.


 * Use ISERR in conjunction with the IF function to test for errors and take different actions in normal and error conditions.

Related LibreOffice functions:
ERROR.TYPE

ISERROR

ISNUMBER

ISTEXT

NA

ODF standard:
Section 6.13.15, part 2

Equivalent Excel functions:
ISERR