Formulas and Functions
Modifying this control will update this page automatically

ISERROR

The ISERROR function returns the Boolean value TRUE if a given expression evaluates to an error, and the Boolean value FALSE otherwise.

ISERROR(any-expression)

any-expression: An expression to be tested. any-expression can contain any value.

Notes

  • It is often better to use the IFERROR function. The IFERROR function provides the functionality of ISERROR, but also allows any expression to be returned, based on the result. ISERROR can only return the Boolean values TRUE or FALSE.

Examples

If B1 is a number value and D1 evaluates to 0, then:

=IF(ISERROR(B1/D1), 0, B1/D1) returns 0 because division by 0 results in an error.

=IFERROR(B1/D1, 0) is equivalent to the previous example, but requires only one function.

See alsoIFERRORISBLANK
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.