Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Mathematics (https://www.askmehelpdesk.com/forumdisplay.php?f=199)
-   -   Some "If" troubles. (https://www.askmehelpdesk.com/showthread.php?t=237373)

  • Jul 14, 2008, 01:36 PM
    vbg1980
    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
  • Jul 15, 2008, 05:16 AM
    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?
  • Jul 15, 2008, 08:04 AM
    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.
  • Jul 15, 2008, 08:30 AM
    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 ")

  • All times are GMT -7. The time now is 09:06 PM.