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