Table of Contents
Summary
The Excel ISERROR function determines whether a value is an error and returns TRUE if an error or FALSE if not an error. The ISERROR function is an Excel error handling function.
Function
=ISERROR(value)
Arguments (inputs)
value = any value to be tested, can be a cell reference, formula, or value
Return value
The ISERROR function returns TRUE if the value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) or FALSE if the value is not an error.
Example
In the example above the ISERROR functions in column H return either TRUE or FALSE, depending on if the values are errors or not. The ISERROR value references in column H are checking for errors in the order totals of column F.
The ISERROR function in cell H8 checks for an error in cell F8. Cell F8 has a #VALUE! error, so ISERROR returns TRUE.
=ISERROR(F8)
The result returned is TRUE, because cell F8 is an error (#VALUE!).
