TOo Many Nested Allowed in IF statement

[britneycook]

Hi Fellas..
Im recieving an error saying that i have too many levels of nesting for my formula

Is there any way to rewrite the formula i have here?

=if(I1>99,0.5,
if(I1>89,0.45,
if(I1>79,0.4,
if(I1>69,0.35,
if(I1>59,0.3,
if(I1>49,0.25,
if(I1>39,0.2,
if(I129,0.15,
if(I1>19,0.1,
if(I1>9,0.05,"TOO SMALL TO SELL"))))))))))

Kindly Britney

[AliGW]

I'd create a lookup formula for something like this.

[ThirtyTwo]

does your formula contain this: " if(I129,0.15, "
where it should be, " if(I1>29,0.15, "

may have just been an error on when you put the formula onto this post

[ThirtyTwo]

Hi Britney

AliGW suggested using a lookup instead of all those nested if's

This is what it would look like if you didn't want to use a table to store the values

Please Login or Register  to view this content.

Regards

32