I was wondering why you started using =count() in situations like this.

But I think that using =isnumber() is easier to understand for a single cell.


Harlan Grove wrote:

"Dave Peterson" wrote...
=if(isnumber(find(...)),"it's there","it's not there")
...

Can save a few keystrokes using COUNT instead of ISNUMBER.

=IF(COUNT(FIND(..)),"found","not found")

--

Dave Peterson