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

# 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
• 5
• 3
• 2
• +1
4 Solutions

Finance AnalystCommented:
Try this:

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

Thanks
Rob H
0

Author Commented:
Thanks rob

I was using and not or....see my mistake
0

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

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

Thanks
0

EngineerCommented:
You can also use something like

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

Mr.Saqib Husain, Syed,

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

New Thing i learned.

Thanks
0

0

EngineerCommented:
Experiment with the find() function alone with the given parameters and you will see it yourself.
0

ok noted :)
0

Finance 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

EngineerCommented:
You are right Rob. Another of my careless mistakes.

Saqib
0

Author 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.