ISERROR Function in Excel identifies the Excel Errors, ISERROR Function returns TRUE if the Excel Error is identified, if not returns FALSE.
Syntax of Excel ISERROR Function:
ISERROR(value)
Where value argument is the Expression or value to be tested for error.
Example of ISERROR Function in Excel:
Formula:
In the above examples divide by 0, #N/A, #VALUE! and #NUM! are Excel errors so ISERROR Function returns TRUE. In other Cases ISERROR Function returns FALSE.
Result:
Note: Difference between ISERR AND ISERROR Function in Excel
- The ISERROR Function returns TRUE, if the supplied value is any Excel error.
- The ISERR Function returns TRUE, if the supplied value is any Excel error except #N/A.
