I'm sure this has a simple solution, but nothing I do seems to work properly.

I am looking for a formula that searches three cells for a specific word. If the word exists in any of the three cells, the output is Yes, if not, the output is No.

Thanks for the help.