Text "comparison" operator for "contains" used in an "IF" Function

[Pawaso]

I'm trying to use an "IF" function to look for a certain word in a string of
text. Is there a "contains" operator for this?

I tried using =if(A1="*example*","yes","no") but this does not seem to work.

 

[Niek Otten]

You can use the FIND function and test for a (non-) error result (ISERROR)

 

[Elkar]

Try this:

=IF(ISERROR(FIND("example",A1,1)),"no","yes")

HTH,
Elkar

 

[Dave Peterson]

=find() is case sensitive
=search() doesn't care about case (Example/EXAMPLE/ExAmPlE will be treated the
same)

another way:

=if(countif(a1,"*example*")>0,"yep","nope")

(not case sensitive)