You are limited to 7 nested "IF's"

For your purposes a lookup table would be more suitable.

Two column table and a VLOOKUP formula.

See Debra Dalgleish's site for excellent instructions on VLOOKUP formulas and a
downloadable sample workbook to assist.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Thu, 28 Sep 2006 11:13:01 -0700, 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(C 5<=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. 99,"3.5",IF(C5<=29.99,"3.375",IF(C5<=39.99,"3.25", IF(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<= 169.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<= 49999.00,"1.33"))


...any suggestions? THANKS!!!!