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

I just need help explaining how to enter it in excel correctly

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.

If this condition is true, the function should multiply cell B9 by 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.)

Copy the formula in B31 to the range C31:G31.

After deductions, Charlie's net monthly commission is only 85% of his gross monthly commission.

In cell B32, create a formula that multiplies the value of cell B31 (Charlie's gross monthly commission) by the value of cell B33 (Charlie's net commission percentage). Use an absolute reference to cell B33 (because the net commission percentage won't change) and a relative reference to cell B31.

Copy the formula in cell B32 to the range C32:G32

Using the Format Painter, copy the formatting from the range G5:G9 to the range H5:H9.

I need this by 12 noon tomorrow

Thanks