You need to determine the commission earned by each Sales Rep, based on the Sales amounts in B3:B50 and the Commission rate specified in cell A1. You want to enter a formula in C3 and copy it down to C50. Which formula should you use?
| A | B | C | |
|---|---|---|---|
| 1 | 8.5% | 2018 Commission | |
| 2 | Sales Rep | 2018 Sales | Commission Earned |
| 3 | Jordan Hinton | $123,938.00 | |
| 4 | Lilah Douglas | $5594,810.00 | |
| 5 | Karyn Reese | $235,954.00 | |
| 6 | Chiquita Walsh | $684,760.00 |