D
David P.
How would I do this?:
=IF(A comma is found in A1),...
Thanks.
=IF(A comma is found in A1),...
Thanks.
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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.
M
Max
=IF(A comma is found in A1),...
=IF(ISNUMBER(SEARCH(",",A1)), ...
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
=IF(ISNUMBER(SEARCH(",",A1)), ...
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
T
T. Valko
Another one:
=IF(COUNT(FIND(",",A1)),.....
Note that this doesn't work on numbers using a number comma format (10,000)
=IF(COUNT(FIND(",",A1)),.....
Note that this doesn't work on numbers using a number comma format (10,000)
J
Joerg Mochikun
Assumes that A1 contains text:
=IF(ISERROR(FIND(",",A1)),"comma not found","comma found")
Joerg
=IF(ISERROR(FIND(",",A1)),"comma not found","comma found")
Joerg
R
Rick Rothstein
Here is another approach...
=IF(LEN(A1)=LEN(SUBSTITUTE(A1,",","")),"No comma","There's a comma")
=IF(LEN(A1)=LEN(SUBSTITUTE(A1,",","")),"No comma","There's a comma")
D
Dave Peterson
One more:
=if(countif(a1,"*,*")>0,"found","not found")
=if(countif(a1,"*,*")>0,"found","not found")
R
Rick Rothstein
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")
to shorten it up a bit...
=IF(COUNTIF(A1,"*,*"),"found","not found")
D
Dave Peterson
I find using the comparison self-documenting.
Rick said: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")
R
Rick Rothstein
That is true enough (but I would guess doing introduces an extra, albeit
very quick, calculation to the formula).
--
Rick (MVP - Excel)
very quick, calculation to the formula).
--
Rick (MVP - Excel)
Dave Peterson said:I find using the comparison self-documenting.
D
Dave Peterson
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.
who are asking this type of question.
And it may make it easier to use the function in different formulas.
Rick said:That is true enough (but I would guess doing introduces an extra, albeit
very quick, calculation to the formula).
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.