Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

i sent in questions that i had to you. I need to know how to put the information into excel.

I pay for help but it seems like i cannot get it. i sent in questions that i had to you. I need to know how to put the information into excel.

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.

please give me instructions on how to put it in excel

I need this by 12 noon tomorrow

Thanks

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question