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:

ISERROR(value)

Where value argument is the Expression or value to be tested for error.

 

Example of ISERROR Function in Excel:

Formula:

ISERROR Function in Excel 1

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:

ISERROR Function in Excel 2

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.

previous-small ISERROR Function in Excel                                                                                                                next_small ISERROR Function in Excel