Multiple IF statement - Alternative method

[mrsushi]

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"))))))))

 

[mrsushi]

How about

=IF(OR(N8={"JPM EM-BIG Price","High Yield","BarCap-GCF","Bloomberg BVAL(BVIC)"}),N8&" Ladder used",IF(N8="Manual","Manually Overwritten",""))

Thanks Fluff...worked a treat!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[mrsushi]

I have another issue which is an IF statement.....

Column D has the narrative "BID". Column E has a BID price and Column G has a Ask Price.

My formula is trying to make the above work ie if D is BID, if E = G, then apply a spread. If not equal to each other then "OK"

Struggling with the below formula

=IF(D5,E5=BID(E5=G5),"INPUT SPREAD","ok")

 

[Fluff]

How about

=IF(AND(D5="BID",E5=G5),"Input spread","Ok")

 

[mrsushi]

How about

=IF(AND(D5="BID",E5=G5),"Input spread","Ok")

Thank you Fluff.

Addition condition, aswell as having the condition "BID", how can the formula be changed and also include "USA". If this is the case and B = USA and E5=G5, I would like the return to be "OK" ( instead of applying a spread)? So effectively 2 conditions ie if E5=G5 and "BID" then "Input Spread, if E5=G5 and "USA" "OK"

Many thanks

 

[Fluff]

No need to change anything, that formula will already do that.

 

[mrsushi]

Cool...many thanks for your assistance again

 

[Fluff]

You're welcome.