The syntax of your formula is OK, it's the logic that's lacking.

Let's take your second argument,
IF(C3=600.01

NOW, doesn't that equate to "True" when C3 contains a value of say, 1000?

That being the case, the formula calculates,
C3+8
AND then *stops* calculating, since a true condition has been met.
It (the formula) never even reaches the other arguments to evaluate them.

What you have to do to 'fix' your formula is reverse the arguments.

Put the larger values at the front of the formula so that the evaluation
does not skip over the lesser values.

Also, take *all* possibilities into consideration, if necessary!

Is it important that if C3 is 0 or negative (<0), or even empty, it will
return the first calculation of
C3+6
?
Is that what you really want to happen (maybe you do)?
If C3 has not yet even been keyed in a value, your formula cell will still
display a 6.

Does this help?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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