IF Formula Problem
I am trying to put thge following formula into one cell (C5) and the formula
error keeps popping. Does anyone have any suggetions how to enter this
formula correctly into one cell?
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"))
|