Quick Navigation
ISERROR Function
Summary
The Excel ISERROR function returns TRUE if a value is any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and FALSE otherwise.
Syntax
ISERROR(value)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| value | Any |
Yes | The value to check for errors |
Using the ISERROR Function
ISERROR is commonly used with IF function to create error-handling formulas before IFERROR was introduced.
Common ISERROR Examples
Basic ISERROR Example
=IF(ISERROR(A2/B2), "Error", A2/B2)Returns "Error" if division results in error, otherwise returns the division result.
Compatibility
Available in: All Excel versions
Content last reviewed: November 24, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+