HI, I have an IF statement which cannot add more if statements because it uses more levels of nesting than are allowed in the current file format.
Is there an alternative way of writing the below formula?
Many thanks
=IF(G3="ORDINARY SHARE","YES",IF(G3="AUTH UNIT TRUST-CAPITAL UNITS","YES",IF(G3="RIGHTS","YES",IF(G3="AUTH UNIT TST-INC(CGT EXEMPT)","YES",IF(G3="ICAV Capital Units","YES",IF(G3="ADR","YES",IF(G3="REIT","YES",IF(G3="OEIC","YES","NO"))))))))
Is there an alternative way of writing the below formula?
Many thanks
=IF(G3="ORDINARY SHARE","YES",IF(G3="AUTH UNIT TRUST-CAPITAL UNITS","YES",IF(G3="RIGHTS","YES",IF(G3="AUTH UNIT TST-INC(CGT EXEMPT)","YES",IF(G3="ICAV Capital Units","YES",IF(G3="ADR","YES",IF(G3="REIT","YES",IF(G3="OEIC","YES","NO"))))))))