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.0 1,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.