using if to find somthing specific

[raccoon588]

i was to place a yes in a cell if K2's text has and *RD* in it at any point. i had the following but it returns a false.


=if(K2="*rd*", "yes", "No")

 

[Logit]

.
Strange. Your formula works here.

 

[Fluff]

How about
=IF(ISNUMBER(SEARCH("rd",K2)),"yes","no")

 

[jtakw]

Hi,

You can also try this:

=IF(COUNTIF(K2,"*rd*"),"Yes","No")