Nested IF statements

N

NancyB

I am trying to calculate a graduated bonus using IF statements. My problem
is that it only recognizes the criteria for the last IF statement.

=IF((B25-D25)<12000,0,IF((B25-D25)>12000<15000,((D25-J25)-12000)*0.25,IF((B25-D25)>15000<17000,((B25-D25)-15000)*0.3+(3000*0.25),IF((B25-D25)>17000,((B25-D25)-17000)*0.35+(3000*0.25)+2000*0.3))))

If production - sales < $12000 then $0 bonus
If production - sales > $12000< $15000 then 25% over $12000
If production - sales > $15000 < $17000 then 30% over $15000
If production - sales > $17000 then 35%

How do I get the formula to stop at the lower limits of the criteria. Now
it just gives me a FALSE answer for anything under $17000.

Thanks for your help!!

NancyB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Range Formula 5
IF statement 9
NESTED ANDIF STATEMENTS 1
Excel nested IF formula question 6
Nested IF Statement Using Dates 5
multiple inputs, multipul outputs (part 2) 3
Help with data not getting plotted 1
Charting challenge/query 0

Top