help with if command

[Greg]

If Cell A1 contains A,B,C,D

what command do I use to say

=if(A1 contains the string C or D or both then print a
Y else print an N) ?


hope I make sense

thanks
Greg

 

[JE McGimpsey]

One way:

=IF(COUNTIF(A1,{"*C*","*D*"}),"Y","N")

 

[Greg]

thats fantastic thanks!

-----Original Message-----
One way:

=IF(COUNTIF(A1,{"*C*","*D*"}),"Y","N")


.