7 11-Vlookup Problem Partial credit will be awarded - do not skip this sheet! 1. Cell D20 requires a If function and two Vlookup functions to pick the correct Percentage from the Lookup Tables in A10 C14. 2. Cell D21 requires simple formula to calculate total earned Note: The forumla in D20 will require both the IF and VLOOKUP functions. We learned about nested IF formulas in Chpater 2 of the textbook. The formula in D21 is the commission percentage (cell D20) times total sales 5 6 Sales Commission Table 8 Training Training not 9 Total Sales completed completed 10 $ 1.00 20% 15% 11 $ 50,000.00 25% 20% 12 $100,000.00 30% 25% 13 $ 150.000.00 35% 30% 14 $200,000.00 40% -35% 15 16 Please Enter Total Sales $ 75,000.00 17 Training Completed Y/N N 1B 19 20 Your commission percentage is 21 Your income is 22 23 Describe a scenario not discussed in class for using a nested IF VLOOKUP formula. How and why would be beneficial or helpful? 25 26 27 28 29 31 32 34 35 ProChart Macro VLOOKUPI port TXT Type here to search O