EXCEL "IF function" used to figure out commission

profileellie4you

  

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 than400000.

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

  • Posted: 11 days ago
  • Due: 
  • Budget: $40000