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

Formulas ->Function Library ->Logical ->IFERROR IFERROR Functions 2. Try This: The IFERROR Function Select: Cell E2. Go to Formulas ->Function Library ->Logical. Click on IFERROR. Value: D2 Value_if_error: "No Data Available" Click OK.   The formula in this example is: =IFERROR(D2,"No Data Available") What Do You See? The answer should be the data in Cell D2. If there is no data, then the result will be our error message: No Data Available. 3. Fill Down the Formula Select: Cell E2. Autofill the equation in Cells E3:E5. Keep going...