I think it makes the formula easier to understand -- especially for the posters
who are asking this type of question.

And it may make it easier to use the function in different formulas.



Rick Rothstein wrote:

That is true enough (but I would guess doing introduces an extra, albeit
very quick, calculation to the formula).

--
Rick (MVP - Excel)

"Dave Peterson" wrote in message
...
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

--

Dave Peterson