vbg1980
Jul 14, 2008, 01:36 PM
I would welcome some help on this. I have pasted the info below. Under the column "outcome", I would like to represent different possible outcomes. For instance, if Row A = Fail, then I want a return of Fail. This is fine.
But I want an answer for if Row A+Row B = Fail, then the Outcome is Fail. Similarly, if RowA+Row B= Pass, then the outcome is Pass. I am tired of trying to think around this, somebody help??
THanks!
Weight outcome
A Fail 30 Fail
B Fail 40
C Fail 30
But I want an answer for if Row A+Row B = Fail, then the Outcome is Fail. Similarly, if RowA+Row B= Pass, then the outcome is Pass. I am tired of trying to think around this, somebody help??
THanks!
Weight outcome
A Fail 30 Fail
B Fail 40
C Fail 30