Using the Excel ISERR Function
SummaryThe Excel ISERR function is one of Excel's IS functions. ISERR checks for an error and returns TRUE for every error except the #N/A error. ISERR can be combined with the IF function to test for errors and then return a custom message or perform another calculation.
If you require a function that identifies all errors, including #N/A, use the ISERROR function.
Required. The value to be checked for any error except the #N/A error. This argument is typically a cell address.
Usage NotesISERR checks to see if a cell contains an error and returns TRUE if an error that is not the #N/A error is found.
The function will catch the following errors: #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, and #NULL!