Excel ISERROR function


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.



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.


Excel ISERROR function 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.


The result returned is TRUE, because cell F8 is an error (#VALUE!).