in cell c5, enter a formula that uses a nested IF function to calculate the bonus. If sales in b5 are less $15,000, the sales person earns a 5% bonus. If the sales are greater than or equal to $15,000 but less than $25,000, the sales person earns a 10% bonus. If sales are more than or equal to $25,000, the sales person earns a 15% bonus.

Question

Compton

Computers & Technology

15 June, 19:11

in cell c5, enter a formula that uses a nested IF function to calculate the bonus. If sales in b5 are less $15,000, the sales person earns a 5% bonus. If the sales are greater than or equal to $15,000 but less than $25,000, the sales person earns a 10% bonus. If sales are more than or equal to $25,000, the sales person earns a 15% bonus.

+4

Answers (1)

Know the Answer?

Corinne Melendez · Answer 1

In C5, the equation should be:

=IF (b5>=25000, b5*0.15, IF (b5>=15000, b5*0.1, b5*0.05))

You want to find the larger values first and work your way down to the lower values.