Charlie wants to calculate his gross monthly sales commissions. The rule is that he receives a…

Charlie wants to calculate his gross monthly sales commissions. The rule is that he receives a commission of 2.5% of his total monthly sales if he sold more than $400,000 worth of vehicles. Otherwise, he only gets 1.5% of his total monthly sales amount.

In cell B31, create a formula using the
IF function to check whether the value of cell
B9is
greater than400000.

If this condition is true, the function should multiply cell
B9by
2.5%to determine Charlie’s commission. (
Hint: For the if true value, use
B9*0.025.)

If this condition is false, the function should multiply the value in cell
B9 by
1.5% to determine Charlie’s commission. (
Hint: For the if false value, use
B9*0.015.)

Attachments:

"Is this question part of your assignment? We can help"

ORDER NOW