Exam 77-428 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.1 Apply Functions in Formulas: Logical Functions (IFERROR)

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