See this:

http://mcgimpsey.com/excel/variablerate.html

--
Biff
Microsoft Excel MVP


"NancyB" wrote in message
...
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