thanks, this helped a lot...now...how do i get it to hide the #NA if the
value is 0?

marcia

"JMB" wrote:

> If you want to use if statements, you have to reorganize it. Once a true
> statement is found, the rest of the formula is not processed. Anything above
> 600.01 will return 8 because this part IF(C3>=600.01,C3+8 will always be true.
>
> =C3+IF(C3>=800.01,20,IF(C3>=700.01,12,IF(C3>=600.01,8,6)))
>
> However, since Excel has a limit of 7 nested functions, I generally avoid
> using IF statements like this. You could try the following, which uses a
> lookup (check excel help for VLOOKUP and the link below - post back if you
> still have questions)
> http://www.contextures.com/xlFunctions02.html
>
> =C3+VLOOKUP(C3,{0,6;600.01,8;700.01,12;800.01,20},2,1)
>
> Instead of putting the lookup table directly in the formula you could create
> the table somewhere in your workbook. and just reference it in the VLOOKUP
> formula. So if the lookup table were in cells A1:B4
>
> A B
> 0 6
> 600.01 8
> 700.01 12
> 800.01 20
>
> the formula becomes
>
> =C3+VLOOKUP(C3,A1:B4,2,1) which will probably look more like the examples
> in excel help.
>
>
>
>
>
>
>
> "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.