Exceljet

Quick, clean, and to the point

Excel ISERROR Function

Excel ISERROR function
Summary 

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.

Purpose 
Test for any error
Return value 
A logical value (TRUE or FALSE)
Syntax 
=ISERROR (value)
Arguments 
  • 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 step-by-step training, 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 how to troubleshoot, trace errors, and fix problems. Start building valuable skills with Excel formulas today. Learn more.

My Lord where have you been all my life?...I've learned more awesome tricks/functions in one afternoon from you than in the last 10 years. - Robert
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course