If a comma is found
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
|