Question

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

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.