ISERROR

The ISERROR function returns TRUE for any type of error, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!, #CALC!, and #SPILL! errors. You can use ISERROR together with the IF function to test for errors and display a custom message, or run a different calculation when an error occurs. The ISERROR function takes one argument, value, which is typically a cell reference. ISERROR will return TRUE if A1 contains an error: You can use the ISERROR function together with the IF function to test for an error and display a custom message if found: To trap an error and perform a different calculation, the IFERROR function is a cleaner approach. Excel provides a number of error-related functions, each with a different behavior: