Lucreziazule
New Member
- Joined
- Jul 11, 2012
- Messages
- 6
Hello,
I know I'm very close to solving this. It might just be my syntax "again"!
I want to combine the two following IF statements.
The Data: is as follows and positioned beginning with the header ENTRY SCORE in A1.
Column A contains "Entry Scores" (numeric value could be negative, zero or a positive value)
Column B contains "Exit Scores" (numeric value could be negative, zero or a positive value)
Column C contains formula to generate results. It should only read the following "be blank", "OK", or "Research"
The Purpose:
In Column C, I would like for the results of the formal to be displayed. Either "Blank" meaning nothing is populated, "OK", or "Research"
If the Exit Score is greater than Entry Score, return "OK"
If the Exit Score is equal to or less than Entry Score, return "Research"
The Two IF Statements I've been using:
1st: I started out using only statement 2 (See #2 in The Formula) in column C and life was grand....but only for a moment. I quickly realized that when the Entry or the Exit Score cells were blank, the formula was returning the result "Research", because really, Nothing is equal to Nothing if you are comparing the two. Also if the Entry Score was a negative value, the formula was returning the result "OK" because "nothing" is greater than a negative value. This is why I think I need IF statement #1. (See #1 underThe Formulas)
2nd: The original formula that fulfills "The Purpose" stated above. I think I should keep it, it works....on a basic level. (See #2 under Formulas)
3rd: My attempt, I really think the syntax is wrong. (See #3 under The Formulas)
The Formulas:
1st: IF(B$2="","")
2nd: IF(B3<=A3,"Research","OK")
3rd: IF(AND(b2="","",b2<=A2,"Research","OK"))
Any assistance is greatly appreciated.
Thanks in advance,
-lou
"May the forces of Evil become confused on the way to your home"
I know I'm very close to solving this. It might just be my syntax "again"!
I want to combine the two following IF statements.
The Data: is as follows and positioned beginning with the header ENTRY SCORE in A1.
Column A contains "Entry Scores" (numeric value could be negative, zero or a positive value)
Column B contains "Exit Scores" (numeric value could be negative, zero or a positive value)
Column C contains formula to generate results. It should only read the following "be blank", "OK", or "Research"
The Purpose:
In Column C, I would like for the results of the formal to be displayed. Either "Blank" meaning nothing is populated, "OK", or "Research"
If the Exit Score is greater than Entry Score, return "OK"
If the Exit Score is equal to or less than Entry Score, return "Research"
The Two IF Statements I've been using:
1st: I started out using only statement 2 (See #2 in The Formula) in column C and life was grand....but only for a moment. I quickly realized that when the Entry or the Exit Score cells were blank, the formula was returning the result "Research", because really, Nothing is equal to Nothing if you are comparing the two. Also if the Entry Score was a negative value, the formula was returning the result "OK" because "nothing" is greater than a negative value. This is why I think I need IF statement #1. (See #1 underThe Formulas)
2nd: The original formula that fulfills "The Purpose" stated above. I think I should keep it, it works....on a basic level. (See #2 under Formulas)
3rd: My attempt, I really think the syntax is wrong. (See #3 under The Formulas)
The Formulas:
1st: IF(B$2="","")
2nd: IF(B3<=A3,"Research","OK")
3rd: IF(AND(b2="","",b2<=A2,"Research","OK"))
Any assistance is greatly appreciated.
Thanks in advance,
-lou
"May the forces of Evil become confused on the way to your home"