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:
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:
