The first IF test that evaluates to TRUE causes the associated 'THEN' clause
to be returned. So if the <=600 test fails, we can be sure that the =600.01
test passes, so the result would be C3+8.
If you have a LOT (7) different ranges, you'll wind up switching to a
vlookup function rather than nested IFs. Otherwise, arrange your tests
differently:
=if(c3=800.01,c3+20,if(c3=700.01,c3+12,if(c3=60 0.01,c3+8,c3+6))).


"gemini0662" wrote:

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.