More levels of nesting than allowed.

[lecxE007]

Just wondering how to shorten the formula below.

=IF
(O6="FLAT",E6-0.032,
IF(O6="2FC","",
IF(O6="2FCB","",
IF(O6="3LEGB",E6-0.032,
IF(O6="3LEGR",E6-0.032,
IF(O6="3LEGL",E6-0.032,
IF(O6="2LEGR",E6-0.032,
IF(O6="2LEGL",E6-0.032,
IF (O6="SPC","",
IF (O6="FS",E6-0.032,
IF (O6="SFLAT",E6-0.032,
IF (O6="S3LEGT",E6-0.032,))))))))))))

 

[T. Valko]

T.Valco,
The last four numbers in rows 15,16 and 18 and 19 are incorrect. I need it to show what is to the left of the yellow cells, in column "needs to be".
Thank you

OK, then I don't understand what you're wanting to do.

 

[lecxE007]

This formula worked great.


=IF(OR(O6={"FLAT","3LEGB","3LEGR","3LEGL","2EGR","2LEGL","FS","SFLAT","S3LEGT"}),"E6-0.032",IF(OR(O6={"2FC","2FCB","SPC"}),""))


Thanks to all.