Wildcards in IF statements

C

Calvin

OK I have tried to do this on my on but..... ok Wildcards in I
statements, can and how is this done
 
P

Peo Sjoblom

There are some ways to do this

=IF(COUNTIF(A2:A2,"?abc"),"yes","no")

=IF(COUNTIF(A2:A2,"*abc"),"yes","no")

=IF(COUNTIF(A2:A2,"*abc*"),"yes","no")

=IF(ISNUMBER(FIND("abc",A2)),"yes","no")

=IF(ISNUMBER(FIND("abc",A2)),"yes","no")

and so on
 
Top