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 (<,>,=)