ISERR Function in Excel

ISERR Function in Excel identifies the Excel Errors Except #N/A, ISERR Function in Excel returns TRUE if the Excel Error is identified except #N/A , if not returns FALSE.

Syntax of ISERR Function in Excel:

ISERR(value)

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

 

Example of ISERR Function in Excel:

Formula:

ISERR Function in Excel 1

In the above examples divide by 0, #VALUE!, #REF! and #NUM! are Excel errors, so ISERR Function returns TRUE. In other Cases (including #N/A) ISERR Function returns FALSE.

Result:

ISERR Function in Excel 2

previous-small ISERR Function in Excel                                                                                                                next_small ISERR Function in Excel