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 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

Leave a Reply

Your email address will not be published. Required fields are marked *