# 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.

**value**- The value to check for any error.

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.