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
|