Multiple conditions within one cell, need help with if/and/or statements

[bobbydacron]

I'm sure this has been answered already, I just can't find it. I'm using Excel 2010 on a windows XP operating system
I'm struggling to create a condition in a cell which I will be using later to export data for a sales training progress report.
In cell A1 there will be one of 4 things :
A) N/a (meaning they dont need to do the test)
B) Open (meaning they still need to do the test, but havent had the course)
C) Their Score
D) Missing (meaning they have attended the class but have not done the test)


I want B1 to say one of 4 things:

1. If "N/a" - then it should say "N/a"
2. If "Open" - then "open"
3. If their score is below 75 or "Missing" then "Not Met"
4. If their score is 75 or above then "Met"

I'm terrible with if/and/or statements. I can do the basic of "score above 75" true, false. However I don't know how to get it to recognize that N/a or open.
Many, many thanks in advance for you help here

 

[Special-K99]

Try this

in B1
=IF(OR(A1="N/A",A1="OPEN"),A1,IF(OR(A1<75,A1="MISSING"),"NOT MET","MET"))

 

[nieve]

Assuming that the cell that provides the information is in a1 then something like
=if (a1="n/a","n/a", if (a1="open","open", if (a1<75,"MISSING","met")))
Not tested but should work

 

[VoG]

Try

=IF(A1="N/a","N/a",IF(A1="Open","Open",IF(OR(A1<75,A1="Mising"),"Not met",IF(A1>=75,"Met",""))))

 

[bobbydacron]

Everyone, I cannot thank all of you enough for your help. I will now look like a complete rock star to my boss!!!!!!!!! especially as I figured out that I could send the "mailing" out via email. Thank you, thank you, thank you!!!!