Improve company productivity with a Business Account.Sign Up

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

if formula based on multiple criteria

Hi Expert's excel 2007

Need a if formula to do the following. ..
If b2 is open or closed or 2nd check or returns then into a2 insert todays date other wise blank.
0
route217
Asked:
route217
  • 5
  • 3
  • 2
  • +1
4 Solutions
 
Rob HensonFinance AnalystCommented:
Try this:

=IF(OR(B2="Open",B2="Closed",B2="2nd Check",B2="Returns"),TODAY(),"")

Thanks
Rob H
0
 
route217Author Commented:
Thanks rob

I was using and not or....see my mistake
0
 
Naresh PatelTraderCommented:
Try this
=IF(OR(B2="Open",B2="Closed",B2="2nd Check",B2="Returns"),TODAY(),"")
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Naresh PatelTraderCommented:
oops confused B2 i guess one cell dosent have too many words as you suggested.


Thanks
0
 
Saqib Husain, SyedEngineerCommented:
You can also use something like

=IF(ISERR(FIND("#"&B2&"#","#Open#Closed#2nd Check#Returns")),"",TODAY())
0
 
Naresh PatelTraderCommented:
Mr.Saqib Husain, Syed,

=IF(ISERR(FIND("#"&B2&"#","#Open#Closed#2nd Check#Returns")),"",TODAY())

New Thing i learned.

Thanks
0
 
Naresh PatelTraderCommented:
May i have explanation please.
0
 
Saqib Husain, SyedEngineerCommented:
Experiment with the find() function alone with the given parameters and you will see it yourself.
0
 
Naresh PatelTraderCommented:
ok noted :)
0
 
Rob HensonFinance AnalystCommented:
Would you not need another # after Returns?

The FIND is trying to find "#Value#" but if Value is "Returns" the FIND will be looking for "#Returns#" which it won't find in the string.

Thanks
Rob H
0
 
Saqib Husain, SyedEngineerCommented:
You are right Rob. Another of my careless mistakes.

Saqib
0
 
route217Author Commented:
Modalot

Firstly apologise forbtge late reply back..cqn you kindly action as per your comments and split points.  Stops me making a mistake.
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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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