Help: IF & OR Criteria - Excel

[Arslan999]

I have below situation where I want "Y" for True, but along with D2,D4 criteria I also want "Y'' if any words starts from O and S as well. Kindly Help

=IF((OR(T54="D4",T54="D2",T54="O",T54="S")),"Y","N")

Thanking you in Advance

 

[AliGW]

Try this:

=IF((OR(T54="D4",T54="D2",T54="O*",T54="S*")),"Y","N")

 

[Arslan999]

Sorry, It didn't work.

 

[AliGW]

OK, well sorry, I'm not clairvoyant. Attach a workbook.

 

[Arslan999]

Dear AliGW
Kindly find attached.

Thank you

 

[bosco_yip]

Try,

=IF((OR(T54="D2",T54="D4",LEFT(T54)="O",LEFT(T54)="S")),"Y","N")

Or,

=IF(OR((T54={"D2","D4"})+(LEFT(T54)={"S","O"})),"Y","N")

Regards

 

[Arslan999]

Try,

=IF((OR(T54="D2",T54="D4",LEFT(T54)="O",LEFT(T54)="S")),"Y","N")

Or,

=IF(OR((T54={"D2","D4"})+(LEFT(T54)={"S","O"})),"Y","N")

Regards

Thanks Alot, Bosco_yip for solution, it worked!

Kind Regards