PDA

View Full Version : Some "If" troubles.


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

ebaines
Jul 15, 2008, 05:16 AM
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
Jul 15, 2008, 08:04 AM
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
Jul 15, 2008, 08:30 AM
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")