Hi,
Try these:
case sensitive
=IF(ISERROR(FIND("YourString",A1)),"No","Yes")
=IF(SUBSTITUTE(A1,"YourString","")=A1,"No","Yes")
not case sensitive:
=IF(COUNTIF(A1,"*YourString*"),"Yes","No")
=IF(ISERROR(SEARCH("YourString",A1)),"No","Yes")
Regards,
KL
"Vstein" wrote in message
...
I am wanting to do an if statement. If cell A contains "a certain word"
then
Y else N. what is the syntax for the the contains portain of the if
statement?
|