+ Reply to Thread
Results 1 to 5 of 5

text value pass or fail

  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    18

    text value pass or fail

    I would like to if in Columns H is a seek help and in columns I Pass than the result to display in Columns L as fail
    I would like to in Columns H as pass and in Columns I damage than the result to display in Columns L as fail
    I would like to in Columns H as pass and in Columns I Pass than the result to display in Columns L as Pass
    In other word if there is a negative opinion in any Columns than it is Fail, and Pass in Columns H and I than pass in Columns l

    Thank you for helping

    Best regards

    wykoems
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: text value pass or fail

    =if(and(H3="pass",I3="pass"),"pass","fail")
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: text value pass or fail

    Another one...

    =IF(H3&I3="passpass","Pass","Fail")

    Copy down as needed.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    04-19-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: text value pass or fail

    Tony Valko and oeldere,

    Thank you both for the answer and I appreciate very much again thank you for making my life simpler

    Best Regards

    wykoems

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: text value pass or fail

    You're welcome. We appreciate the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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