If anyone of these cells are greater than 10 return a yes, if not no

Try:

Formula:

Please Login or Register  to view this content.

What if you r looking for a word in a range of cells and that word is in there it returns a true

If you want to check if the cell contains only and exactly the word, use:

Formula:

Please Login or Register  to view this content.

So, this would return TRUE if a cell contained 'foo', but FALSE if it contained 'foobar'



If you want to check if the word exists at all, in part of a cell, use:

Formula:

Please Login or Register  to view this content.

So this would return TRUE if a cell contained 'foo', or 'foobar', or 'bluefoopoo'

=SUMPRODUCT(--(ISNUMBER(SEARCH(" "&"foo"&" "," "&$A$1:$J$1&" "))))>0 will count only foo not foobar or football