I find using the comparison self-documenting.

Rick Rothstein wrote:

I like this one best... one function call. Let's remove the comparison just
to shorten it up a bit...

=IF(COUNTIF(A1,"*,*"),"found","not found")

--
Rick (MVP - Excel)

"Dave Peterson" wrote in message
...
One mo

=if(countif(a1,"*,*")0,"found","not found")

David P. wrote:

How would I do this?:

=IF(A comma is found in A1),...

Thanks.
--
David P.

--

Dave Peterson

--

Dave Peterson