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

ebaines

Please clarify - are you trying to do this in Excel? You would use a nested IF command. However, you haven't clarified what response you want if Row A = Pass and Row B = Fail - would you want the outcome to be Fail in that case?

vbg1980

Yes, I am trying to do this in Excel. I have tried using Nested If. If Row A=Pass and Row B = Fail then yes, I would want the outcome to be a Fail.

Thanks.!

ebaines

OK - suppose you have either "Pass" or "Fail" in cells A1, A2, and A3, and you want a response of "Pass" or "Fail" to appear in cell A4 per the rules you stated. In cell A4 you would put the following:

if(and(A1="Pass",A2="Pass",A3="Pass"),"Pass","Fail ")