• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 836
  • Last Modified:

I need an excel formula

OK guys, last one for the day...

I am needing a formula that will look at two criteria instead of 1. I got this one earlier from Barryhoudini, but I need to add another criteria to it that I am not getting to work.

=(C6="Closed")+0

I need it to include "Closed" and "Complete - Successful"
0
wrt1mea
Asked:
wrt1mea
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
=(OR(C6="Closed",C6="Complete - Successful"))+0

Kevin
0
 
cyberkiwiCommented:
=(C6="Closed")+(C6="Complete - Successful")
0
 
wrt1meaAuthor Commented:
Works great!
0
 
MoznmarCommented:
If you want either "Closed" or "Complete-Successful", then use zorvek's solution:

=(OR(C6="Closed",C6="Complete - Successful"))+0

The suggestion provided by cyberwiki will work if you want to require C6 to contain both "Closed" and "Complete-Successful".
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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now