The ISERR Function checks whether a value is an error of #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!, except #N/A error.
Formula:
= ISERR(value)
Explanations:
Value is required, when the value is any of the following error: #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL!", the result returns True, or returns False when the cell is not any of these errors.
Cautions:
#N/A error is excluded and ISERR(#N/A) returns false.
=ISERR(A2)
Cell A2 is #VALUE! error, ISERR(#VALUE!) returns to TRUE.
=ISERR(A10)
Cell A10 is number 21, ISERR(21) returns to FALSE.