Documentation/Calc Functions/ISERR
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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
=ISERR(X)is equivalent to the formula=IF(ISNA(X); FALSE(); ISERROR(X)). - Use ISERR in conjunction with the IF function to test for errors and take different actions in normal and error conditions.
Examples:
| Formula | Description | Returns |
|---|---|---|
| =ISERR(12.34) | Here the function returns the logical value FALSE. | FALSE |
| =ISERR("Hello world!") | Here the function returns the logical value FALSE. | FALSE |
| =ISERR(TRUE()) | Here the function returns the logical value FALSE. | FALSE |
| =ISERR(2021-12-18) | Here the function returns the logical value FALSE. | FALSE |
=ISERR(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 |
=ISERR(D2) where cell D2 contains the formula =SQRT(-7). |
Here cell D2 contains an invalid argument error (Err:502) and so ISERR returns the logical value TRUE. | TRUE |
=ISERR(D3) where cell D3 contains the formula =NA(). |
Here cell D3 contains a #N/A error and so ISERR returns the logical value FALSE. | FALSE |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
ISERR