Quick, clean, and to the point

Excel ISERROR Function

Excel ISERROR function

The Excel ISERROR function returns TRUE for any error type that excel generates, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! You can use the ISERR function together with the IF function to test for an errors and display a custom message, or run a different calculation when found.

Test for any error
Return value 
A logical value (TRUE or FALSE)
=ISERROR (value)
  • value - The value to check for any error.
Usage notes 

Use the ISERROR function to see if a cell contains any error message, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!

For example, =ISERROR(A1) will return TRUE if A1 is is displaying an one of the errors mentioned above , and FALSE if not.

Frequently, value is supplied as a cell address, but you can use it to trap errors inside more complex formulas as well.

Excel Formula Training

Formulas are the key to getting work done in Excel. In this accelerated video course, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn powerful skills to troubleshoot, trace errors, and fix problems. This is the formula training you should have had to begin with. See details here.

I really appreciate your site and your helpfulness. I think you, your videos and your site are very valuable tools. - Jason
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course