Yes, there is a "contains" operator that you can use in an "IF" function to look for a certain word in a string of text. The operator you can use is the asterisk (*) symbol, which is a wildcard character that represents any number of characters.

To use the "contains" operator in an "IF" function, you can modify your formula to the following:

1. Formula:

   =IF(ISNUMBER(SEARCH("example",A1)),"yes","no") 


In this formula, the SEARCH function is used to look for the word "example" in cell A1. If the word is found, the function returns the position of the first character of the word in the text string. If the word is not found, the function returns the #VALUE! error.

The ISNUMBER function is then used to check if the result of the SEARCH function is a number (i.e. the word was found). If the result is a number, the function returns TRUE. If the result is an error, the function returns FALSE.

Finally, the IF function is used to return "yes" if the word was found (i.e. the result of the ISNUMBER function is TRUE), and "no" if the word was not found (i.e. the result of the ISNUMBER function is FALSE).