Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

formulae which will identify the presence of a dot (.)

Dear experts

Need a formulae which will identify the presence of a dot (.) in a text string and if the condition is met, the formulae will return true.

Example (cell A2)

Xyz.xls      Formulae should return ‘True’

The idea is that if the result of the find/search formulae is true, then i would like to put “”, no character, else put the valuein the cell A2.

Kindly provide the formulae for the same.

Thank you
0
Excellearner
Asked:
Excellearner
  • 4
  • 3
  • 3
  • +3
3 Solutions
 
StephenJRCommented:
This perhaps?

=IF(ISNUMBER(FIND(".",F1)),F1,"")
0
 
SiddharthRoutCommented:
Try this

Where A1 has the text

=IFERROR(IF(FIND(".",A1,1),"True","False"),"False")

Sid
0
 
RunriggerCommented:
=IF(ISERROR(FIND(".",A2,1)),FALSE,TRUE)
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
StephenJRCommented:
I guess you want A1 rather than F1.
0
 
SiddharthRoutCommented:
Shortened it to

=IFERROR(IF(FIND(".",A1,1),"True"),"False")

Sid
0
 
kostyakCommented:
What you probably want to do is use the following:
=NOT(ISERROR(FIND(".",A2)))

Open in new window

0
 
RunriggerCommented:
IFERROR only available in Excel 2007 and later!
0
 
SiddharthRoutCommented:
Runrigger: Yes you are right.
Excellearner: Which Excel version are you using?

Sid
0
 
barry houdiniCommented:
You could also use COUNTIF

=IF(COUNTIF(A1,"*.*"),"",A1)

regards, barry
0
 
barry houdiniCommented:
....but I should say that StephenJR,s approach is first and best IMO

barry
0
 
Rory ArchibaldCommented:
If you just want True/False, then:
=ISNUMBER(FIND(".",A2))
0
 
Rory ArchibaldCommented:
Missed the last part of the Q, so I agree Stephen's does exactly what you want. :)
0
 
RunriggerCommented:
Barry/Rory, kindly advise IYO

is?
=IF(ISNUMBER(FIND(".",F1)),F1,"")

better than?
=IF(ISERROR(FIND(".",F1)),"",F1)

clearly I have slightly modified my formula @34863823 and I agree that Stephen's response is more complete given the later part of the question, I just wondered if ISNUMBER is better/more efficient than ISERROR?
0
 
barry houdiniCommented:
I doubt if there's much in it really, Runrigger. I think I have a slight preference for ISNUMBER because it's a positive test......but that's probably just me.

Otherwise which one you use might depend on how you need to structure any other parts of the formula. In this case, in a simple IF function, obviously you can just swap the TRUE/FALSE arguments as per your example so it probably doesn't matter....

regards, barry
0
 
RunriggerCommented:
Thanks for the feed back Barry, I didn't think there would be much in it, but a positive test I guess is the better approach!
rgds
Dave
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 3
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now