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

/in /by

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 theIF function to check whether the value of cellB9isgreater than400000.
If this condition is true, the function should multiply cellB9by2.5%to determine Charlie’s commission. (Hint: For the if true value, useB9*0.025.)
If this condition is false, the function should multiply the value in cellB9 by1.5% to determine Charlie’s commission. (Hint: For the if false value, useB9*0.015.)