FORMULA

[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

[Casey]

Fran,
I would approach this problem differently. I would make a table on 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 the values change, you just have to change the little table not all those formulas.

HTH

[Anne Troy]

Hi, Fran. If you set up a table for your values and use VLOOKUP, you can
easily change the values later in the table without having to update your
formula. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Fran" <[email protected]> wrote in message
news:[email protected]...
>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

[Fran]

Thanks I'll check it out.

"Anne Troy" wrote:

> Hi, Fran. If you set up a table for your values and use VLOOKUP, you can
> easily change the values later in the table without having to update your
> formula. See:
> http://www.officearticles.com/excel/...soft_excel.htm
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Fran" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>