+ Reply to Thread
Results 1 to 5 of 5

Help with Pass/Fail Problem

  1. #1
    Registered User
    Join Date
    09-03-2015
    Location
    Sunny Cali
    MS-Off Ver
    2007
    Posts
    16

    Help with Pass/Fail Problem

    Hi All,
    This is my first time posting here and I know this should be a quick one. I regularly am able to find the answers to what I need based on other folk's questions, which is greatly helpful!

    My problem is in the attached picture, but if it isn't clear, what I am trying to do is populate the "Unit Pass/Fail" column with either "Pass" or "Fail" (Pass if ALL "Pass/Fail" columns = Pass; Fail if ANY "Pass/Fail" columns = Fail), so basically a 100% is required to pass or it's an automatic fail.

    This might be a simple IF function, but I've tried so many that I now must seek counsel from the Excel gurus!!!

    Thanks in advance for your help!!


    Fail-Pass.jpg

  2. #2
    Forum Contributor
    Join Date
    06-28-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    308

    Re: Help with Pass/Fail Problem

    if(and(and(d1="Pass",f1="Pass"),h1="Pass"),"Pass","Fail")

    Should work I think

    Sorry, I should be more clear...

    if(and(and(d2="Pass",f2="Pass"),h2="Pass"),"Pass","Fail") in cell G2, then drag down.
    Last edited by TheN; 07-28-2016 at 07:59 PM.

  3. #3
    Registered User
    Join Date
    09-03-2015
    Location
    Sunny Cali
    MS-Off Ver
    2007
    Posts
    16

    Re: Help with Pass/Fail Problem

    Thanks TheN for the prompt response....unfortunately that trick didn't work... I've attached another picture that captures the spreadsheet in it's entirety to help a little more.

    Fail-Pass2.jpg

  4. #4
    Forum Contributor
    Join Date
    06-28-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    308

    Re: Help with Pass/Fail Problem

    if(and(and(and(d3="Pass",f3="Pass"),h3="Pass"),j3="Pass"),"Pass","Fail") in cell K3 and drag down

    Updated, I originally missed that J was part of the pass/fail, sorry about that.
    Last edited by TheN; 07-28-2016 at 08:09 PM.

  5. #5
    Registered User
    Join Date
    09-03-2015
    Location
    Sunny Cali
    MS-Off Ver
    2007
    Posts
    16

    Re: Help with Pass/Fail Problem

    TheN,
    You've solved my torturous riddle!!! Thank you so much, it worked like a charm!! Have a great day!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pass or fail?
    By anri.scooter in forum Excel General
    Replies: 4
    Last Post: 07-21-2015, 03:38 AM
  2. PASS or FAIL
    By HansWitt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-18-2015, 06:00 AM
  3. [SOLVED] Need a formula for pass/fail based on no. of Y answers but automatically fail if 3a is N
    By Researcher1111 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-15-2013, 10:20 PM
  4. [SOLVED] Pass And Fail
    By thong127 in forum Excel General
    Replies: 9
    Last Post: 06-11-2013, 05:17 PM
  5. text value pass or fail
    By wykoems in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-19-2013, 08:41 AM
  6. Pass/Fail Percentages
    By cheech1206 in forum Excel General
    Replies: 4
    Last Post: 04-13-2011, 11:59 AM
  7. [SOLVED] pass fail
    By Tricia in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-20-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1