D
David P.
What formula would accomplish:
If no comma found in A1 then...
If no comma found in A1 then...
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
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
=IF(ISERROR(SEARCH(",",A1)), etc
or
=IF(NOT(ISNUMBER(SEARCH(",",A1))), etc
You can also use FIND instead of SEARCH.
Hope this helps.
Pete
G
Gary''s Student
=IF(LEN(SUBSTITUTE(A1,",",""))=LEN(A1),"no comma","its got comma(s)")
D
Dave Peterson
One more:
=if(countif(a1,"*,*")=0,"No comma","At least one")
=if(countif(a1,"*,*")=0,"No comma","At least one")
S
Shane Devenshire
Hi,
To add flexibility enter the search item in another cell, say C1 and then
=IF(SEARCH(C1,A1),"found","not found")
To add flexibility enter the search item in another cell, say C1 and then
=IF(SEARCH(C1,A1),"found","not found")
T
T. Valko
=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".