bobbydacron
New Member
- Joined
- Jan 20, 2013
- Messages
- 3
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:
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
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:
- If "N/a" - then it should say "N/a"
- If "Open" - then "open"
- If their score is below 75 or "Missing" then "Not Met"
- 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