Thread: FORMULA
View Single Post
  #1   Report Post  
Fran
 
Posts: n/a
Default FORMULA

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