Excel Help: if then searching multiple cells
 

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.

Excel Help: if then searching multiple cells
 

1000ROUNDS explained :
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.

Look into the COUNTIF() function in online help...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc