IF Formula Help

[garymu16]

Hi all,

=IF(B26<50001,16,IF(B26<100001,32,IF(B26<150001,48,IF(B26<200001,64,IF(B26<250001,80, IF(B26<300001,96,IF(B26<350001,112,IF(B26<400001,128))))))))

The above IF formula works perfectly, however, when I add another IF statement to it (,IF(B26<450001,144)) then I get an error message stating the the Formula contains an error. I actually need to add another 3 IF statements onto the end of the above noted formula.

Is there a limit to the number of IF's you can use? Is there a better way to do this formula?

Thx

Gary

 

[Aladin Akyurek]

Hi all,

=IF(B26<50001,16,IF(B26<100001,32,IF(B26<150001,48,IF(B26<200001,64,IF(B26<250001,80, IF(B26<300001,96,IF(B26<350001,112,IF(B26<400001,128))))))))

The above IF formula works perfectly, however, when I add another IF statement to it (,IF(B26<450001,144)) then I get an error message stating the the Formula contains an error. I actually need to add another 3 IF statements onto the end of the above noted formula.

Is there a limit to the number of IF's you can use? Is there a better way to do this formula?

Thx

Gary

Create a table of 2 columns, say in F:G, like this:

0,16
50000,32
100000,48
...

then invoke:

=LOOKUP(B26,$F$12:$G$12)