| A | B | C | |
|---|---|---|---|
| 1 | 8.5% | 2018 Commission | |
| 2 | Sales Rep | 2018 Sales | Comenion 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 |
- =$A1*B3
- =$A$1*B3
- =A1*$B3
- =A1*B3
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?
June 29, 2021June 29, 2021
0 Comment