ISERROR Function in Excel – Identify Excel Errors

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:

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.