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" wrote in message
...
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(D375,"3.350",IF(D370,"2.034",IF(D365,"1.152 ",IF(D360,".738",IF(D355,".630",IF(D350,".387", IF(D345,".252",IF(D340,".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