Try this:

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

HTH,
Elkar

"Pawaso" wrote:

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.