Hi Kris

I think there are too many conditions - Please see this information from Ms
Excel Help:

Up to seven IF functions can be nested as value_if_true and value_if_false
arguments to construct more elaborate tests. If you want to test more than
seven conditions, consider using the LOOKUP, VLOOKUP, or HLOOKUP function.

I suggest that you create a list of values and then use Vlookup to pick up
this values.

Hope this helps









"kris" wrote:

I am trying to enter multiple IF values into one cell. I enter all the values
and when I try to close out of the formula an error comes up and will not let
me. Do I have too many values? here is what I am trying to enter:


IF(C5<=0.49,"6",IF(C5<=0.99,"5.75",IF(C5<=1.49,"5. 5",IF(C5<=1.99,"5",IF(C5<=2.49,"4.75",IF(C5<=2.99, "4.75",IF(C5<=3.99,"4.5",IF(C5<=4.99,"4.375",IF(C5 <=5.99,"4.25",IF(C5<=6.99,"4.125",IF(C5<=7.99,"4", IF(C5<=8.99,"3.75",IF(C5<=9.99,"3.625",IF(C5<=19.9 9,"3.5",IF(C5<=29.99,"3.375",IF(C5<=39.99,"3.25",I F(C5<=49.99,"3.125",IF(C5<=59.99,"3",IF(C5<=69.99, "2.75",IF(C5<=79.99,"2.625",IF(C5<=89.99,"2.5",IF( C5<=99.99,"2.3332",IF(C5<=139.99,"2.2499",IF(C5<=1 69.99,"2.1666",IF(C5<=199.99,"2",IF(C5<=239.99,"1. 855",IF(C5<=269.99,"1.8225",IF(C5<=299.99,"1.7862" ,IF(C5<=349.99,"1.75",IF(C5=399.99,"1.725",IF(C5<= 499.99,"1.6875",IF(C5<=749.99,"1.6",IF(C5<=999.99, "1.55",IF(C5<=1499.99,"1.5",IF(C5<=1999.99,"1.45", IF(C5<=2999.99,"1.4",IF(C5<=4999.99,"1.35",IF(C5<= 9999.99,"1.3375",IF(C5<=24999.99,"1.3333",IF(C5<=4 9999.00,"1.33"))


...any suggestions? THANKS!!!!