Ask Experts Questions for FREE Help !
Ask
    vbg1980's Avatar
    vbg1980 Posts: 10, Reputation: 1
    New Member
     
    #1

    Jul 14, 2008, 01:36 PM
    Some "If" troubles.
    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's Avatar
    ebaines Posts: 12,131, Reputation: 1307
    Expert
     
    #2

    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's Avatar
    vbg1980 Posts: 10, Reputation: 1
    New Member
     
    #3

    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's Avatar
    ebaines Posts: 12,131, Reputation: 1307
    Expert
     
    #4

    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 ")

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Intertherm Electric Furnace Blower works in "on" not in "auto" [ 6 Answers ]

I have an Intertherm Electric Furnace E2EB-015AH. I came home from work last night, turned the heat on and it didn't work as advertised. I could hear the relays clicking occasionally so I investigated a little and found the elements are heating up and cycling, the relay inside the thermostat cycles...

Oscar De La Hoya "Golden Boy" vs Floyd "Money" Mayweather Part 2 [ 1 Answers ]

Who would win between these 2. Oscar De La Hoya "Golden Boy" vs Floyd "Money" Mayweather Part 2 My vote is for Oscar to win this time by unanamous decision.


View more questions Search