Question

The bonus rates for each salesperson are determined by sales amounts using the following scale:__________.
Sales greater than $35,000 earn a bonus rate of 5%, sales greater than $25,000 earn a bonus rate of 4%.
All other sales (any amount greater than 0) earn a bonus rate of 2%.
With the sheets still grouped, in cell C5 use an IFS function to determine the commission rate for the first salesperson whose sales are in cell B5.
Fill the formula down through cell C8.

Answer 1

Answer:

=IF(C5>35000,IF(C5>25000<35000,IF(C5<25000,0.05*C5),0.04*C5),0.02*C5)

Explanation:

The formula to be placed in cell C8 is provided below :

=IF(C5>35000,IF(C5>25000<35000,IF(C5<25000,0.05*C5),0.04*C5),0.02*C5)

The cell will calculate the bonus according to the given data, the given data is placed in the cell using IF formula. The formula starts with = and then writing IF then applying all the terms.