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" <gemini0662@discussions.microsoft.com> wrote in message
news:FCE47366-F825-4BD1-AFC0-06CF9A36CE02@microsoft.com...
> 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.