Because the =600 condition has already been met............reverse the
order of your conditions, start with 800, then 700 etc.......working your
way down instead of up..........

Vaya con Dios,
Chuck, CABGx3


"gemini0662" wrote in message
...
i am trying to get a formula to increase the dollar amount per $100.00 and
have been able to get the first part. i am not sure how to get the $$$ to
increase since there are a number of arguments per category.


=IF(C3<=600,C3+6,IF(C3=600.01,C3+8,IF(C3=700.01, C3=12,IF(C3=800.01,C3+20)
)))

this formula will not recalculate over 700.00 and up...any suggestions?
clear explanations would be appreciated since i am new to the formula
world.
the last formula i came up withfor a different project was pieced together
from several different spreadsheets.