+ Reply to Thread
Results 1 to 7 of 7

PASS or FAIL

  1. #1
    Registered User
    Join Date
    06-18-2015
    Location
    Glasgow
    MS-Off Ver
    2010
    Posts
    3

    PASS or FAIL

    Hi,

    I'm looking for a solution for the following issue:

    i have three cells A1, A2, and A3, if A1=A2=A3 it should show PASS in other Cell e.g. A4 if not = it should show FAIL


    PASS or FAIL should be visible only if we fill all 3 cells


    Thank You for help

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,264

    Re: PASS or FAIL

    =IF(AND(A1=B1,B1=C1),"Pass","Fail")

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,264

    Re: PASS or FAIL

    Should be ..

    =IF(AND(A1=A2,A2=A3),"Pass","Fail")

  4. #4
    Registered User
    Join Date
    06-18-2015
    Location
    Glasgow
    MS-Off Ver
    2010
    Posts
    3

    Re: PASS or FAIL

    the problem is that even when cells are empty it shows PASS. How to change this function to make visible only if we type something in Cells A1, A2 and A3.

    Sorry for my English

  5. #5
    Forum Contributor
    Join Date
    03-17-2005
    Location
    Canterbury, Kent
    MS-Off Ver
    2003, 2010
    Posts
    285

    Re: PASS or FAIL

    This will leave A4 blank if one of the cells is empty.

    =IF(COUNT(A1:A3)<3,"",IF(AND(A1=A2,A2=A3),"Pass","Fail"))

    Windy

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,264

    Re: PASS or FAIL

    Yes .. I had thought about blank cells ... but you have a solution from "Windy58" (thanks)

  7. #7
    Registered User
    Join Date
    06-18-2015
    Location
    Glasgow
    MS-Off Ver
    2010
    Posts
    3

    Re: PASS or FAIL

    thank you very much for help guys working fine

+ 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. [SOLVED] Pass,Fail or blank
    By DougHarty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-13-2018, 10:07 AM
  2. [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
  3. [SOLVED] Pass And Fail
    By thong127 in forum Excel General
    Replies: 9
    Last Post: 06-11-2013, 05:17 PM
  4. text value pass or fail
    By wykoems in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-19-2013, 08:41 AM
  5. 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