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, formula using the

IF

function to check whether the value of

cell

B9

is

greater than

400000

.

a.

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

.)

b.

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