What formula would accomplish:

If no comma found in A1 then...
--
David P.

Try this:

=IF(ISERROR(SEARCH(",",A1)), etc

or

=IF(NOT(ISNUMBER(SEARCH(",",A1))), etc

You can also use FIND instead of SEARCH.

Hope this helps.

Pete

On Dec 9, 12:30*am, David P. wrote:
What formula would accomplish:

If no comma found in A1 then...
--
David P.

=IF(LEN(SUBSTITUTE(A1,",",""))=LEN(A1),"no comma","its got comma(s)")

--
Gary''s Student - gsnu200819

One mo
=if(countif(a1,"*,*")=0,"No comma","At least one")

David P. wrote:

What formula would accomplish:

If no comma found in A1 then...
--
David P.

--

Dave Peterson

Hi,

To add flexibility enter the search item in another cell, say C1 and then

=IF(SEARCH(C1,A1),"found","not found")

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"David P." wrote:

What formula would accomplish:

If no comma found in A1 then...
--
David P.

=IF(SEARCH(C1,A1),"found","not found")

If the item isn't found that formula will return an error. It will *never*
return "not found".


--
Biff
Microsoft Excel MVP


"Shane Devenshire" wrote in
message ...
Hi,

To add flexibility enter the search item in another cell, say C1 and then

=IF(SEARCH(C1,A1),"found","not found")

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"David P." wrote:

What formula would accomplish:

If no comma found in A1 then...
--
David P.