Commission. The same problem as the one used in Excel A2; the difference is that in A2 the commission rate was determined through nested IF, while here the commission rate is to be determined through a VLOOKUP

Name Rep Q2 Q2 Commission Q3 Q3 Commission Sales (S) ($) Sales ($) (5) Commission Rates Adam $ 1,200 $ 1,500 Threshold ($) Rate Ben $ 299 $ 499 0.00% Candy $ 300 $ 400 300 1.50% Dan $ 1,000 $ 1,999 $ 500 2.00% Edward $ 299 $ 500 1,000 2.20% Frank $ 300 $ 499 $ 2,000 2.50% $ 400 $ 499 Hank $ 1,995 $ 2,000 If a sales amount reaches (Note: The logic is similar to that of determining grades - A-B-C-D-F) the threshold on column F, the rep will be entitled to the Hint: Commission = Sales X ComRate, and ComRate is to be found thru VLOOKUP thru VLOcorresnonding rate in G Greg