FORMULA

F

Fran

I need to write an if then statement that contains more than 7 nested levels
how do I do that. So far I have:

=IF(D3>75,"3.350",IF(D3>70,"2.034",IF(D3>65,"1.152",IF(D3>60,".738",IF(D3>55,".630",IF(D3>50,".387",IF(D3>45,".252",IF(D3>40,".153",".063"))))))))

which works, but soon as I add another IF statement it gives me an error
message.
I need to add 2 more IF statements for this formula to work....

Thanks
 
C

Casey

Fran,
I would approach this problem differently. I would make a table o
another sheet. Something like this on say Sheet1 A1:B10:

Column A Column B
75 3.350
70 2.034
and so on....................

Then use a formula like this

IF(D3<>"",VLOOKUP(D3,Sheet1!A1:B10,2,FALSE),0)

Then you can have as many choices as you need and if in the future th
values change, you just have to change the little table not all thos
formulas.

HT
 
Top