F J 6 6 6 6 6 A B D E F G H 1 Lname: Fname: 2 Rep Q2 Q2 Commission Q3 Q3 Commission 3 Name Sales ($) ($) Sales (S) ($) Commission Rates 4. Adam $ 1,200 $ 1,500 Threshold ($) Rate 5 Ben 299 $ 499 $ 0.00% 6 Candy $ 300 $ 400 $ 300 1.50% 7 Dan 1,000 $ 1,999 500 2.00% 8 Edward $ 299 $ 500 $ 1,000 2.20% 9 Frank $ 300 $ 499 $ 2,000 2.50% 10 Greg $ 400 $ 499 11 Hank $ 1,995 $ 2,000 li a sales amount reaches 12 (Note: The logic is similar to that of determining grades - A-B-C-D-F) the threshold on column F, 13 the rep will be entitled to the 14 correspondino rate in G 15 Hint: Commission = Sales X ComRate, and ComRate is to be found thru VLOOKUP 16 Critical Q: Is this lookup "Range" or "Non-range"? Solution would be right there once this question is answered correctly. 17 18 Last HW, it was Sales * IF; 19 now, it's Sales * VLOOOKUP 20 21 22 23 24 25 26