GET READY. USE the workbook from the previous exercise and make sure the Performance worksheet is active. Select cell E11 and click to place the insertion point after the = in the formula bar to edit the formula. You add the IFERROR formula to correct the formula error that gave the #N/A result in a previous exercise. Type IFERROR( before VLOOKUP. Leave the existing formula intact. Press End to take you to the end of the formula. At the end of the original formula, type ,0). As shown below, the complete formula is =IFERROR(VLOOKUP(B11,Bonus,2,True),0). Be sure to include the closing paren- thesis and the preceding comma or Excel returns an error that the formula is incorrect. Press Enter. The #N/A error message is replaced by 0. If you select cell E11 and click the Insert Function button next to the formula bar, the original VLOOKUP formula appears in the Value box (first argument) in the IFERROR formula. As illustrated below, that argument returned a #N/A error. The Value_if_error box contains the 0 that replaces the error message. Click cell F11 and edit the formula to include the IFERROR function =IFERROR(VLOOKUP(B11,Bonus,3),0). Copy the formulas in E11:F11 to E5 through F10. The workbook doesn’t look like it changes, but you should verify that this worked by changing B6 to 0 (as shown below). Click Undo to reverse the change to cell B6 and return the worksheet to the proper values. the 10 Fabrikam Bonus Solution workbook again. SAVE CLOSE the workbook and LEAVE Excel open for the next exercise. IFERROR recognizes and evaluates the following errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. In this exercise, you replace the #N/A error message with 0”.
GET READY. USE the workbook from the previous exercise and make sure the Performance worksheet is active. Select cell E11 and click to place the insertion point after the = in the formula bar to edit the formula. You add the IFERROR formula to correct the formula error that gave the #N/A result in a previous exercise. Type IFERROR( before VLOOKUP. Leave the existing formula intact. Press End to take you to the end of the formula. At the end of the original formula, type ,0). As shown below, the complete formula is =IFERROR(VLOOKUP(B11,Bonus,2,True),0). Be sure to include the closing paren- thesis and the preceding comma or Excel returns an error that the formula is incorrect. Press Enter. The #N/A error message is replaced by 0. If you select cell E11 and click the Insert Function button next to the formula bar, the original VLOOKUP formula appears in the Value box (first argument) in the IFERROR formula. As illustrated below, that argument returned a #N/A error. The Value_if_error box contains the 0 that replaces the error message. Click cell F11 and edit the formula to include the IFERROR function =IFERROR(VLOOKUP(B11,Bonus,3),0). Copy the formulas in E11:F11 to E5 through F10. The workbook doesn’t look like it changes, but you should verify that this worked by changing B6 to 0 (as shown below). Click Undo to reverse the change to cell B6 and return the worksheet to the proper values. SAVE the 10 Fabrikam Bonus Solution workbook again. CLOSE the workbook and LEAVE Excel open for the next exercise. IFERROR recognizes and evaluates the following errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. In this exercise, you replace the #N/A error message with 0”.
step_by_step_10-_excel.docx