1. 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 B9 is greater than 400000.

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

What formula do i put in for Part A?