Logical Functions: IFERROR

The IFERROR function determines if there are any problems with the data. Here are a few of the problems that can be found:


#N/A (not enough data),

#VALUE! (different data types, such as adding a number to a date),

#REF! (a lost cell reference),

#DIV/0! (a divide by zero error)

#NAME? Where's the Named Range)

or #NULL!. (an empty cell with no data).
Before You Begin: Add Another Column

Select Column E.

Go to Home->Cells->Insert.

There should a new, blank Column E.


1. Try it: Create a Logical Formula
Select Cell E1 and type: IFERROR.
Select Cell E1 and format the label BOLD.


Keep going...

Formulas ->Function Library ->Logical ->IFFERROR

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.4. Apply conditional logic in a formula (<,>,=)