Roz wants to calculate her gross monthly sales commissions. The rule is that she gets a 2.7% commission on the total sales amount every month, and she receives 3.5% if her sales exceeded $80,000 in a given month. In cell B31, create a formula using the IF function to check whether the value of cell B10 is greater than 80000. If this condition is true, the function should multiply cell B10 by 3.5% to determine Roz’s commission. (Hint: For the if true value, use B10 x 0.035.) If this condition is false, the function should multiply the value in cell B10 by 2.7% to determine Roz’s commission. (Hint: For the if false value, use B10 x 0.027.)
What is the correct formula?
A. =IF(B10 > 80000, B10 x 0.035, B10 x 0.027)
B. =IF(B10 <= 80000, B10 x 0.035, B10 x 0.027)
C. =IF(B10 > 80000, B10 x 0.027, B10 x 0.035)
D. =IF(B10 <= 80000, B10 x 0.027, B10 x 0.035)