+ Reply to Thread
Results 1 to 4 of 4

Columns H is seek help than I want the formula in Columns J to show Fail

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

    Columns H is seek help than I want the formula in Columns J to show Fail

    Formula: help with this stage of worksheet

    If the text in Columns H is pass than I want the formula in Columns J to show Pass

    If the text in Columns H is seek help than I want the formula in Columns J to show Fail
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Doha, State of Qatar
    MS-Off Ver
    excel 2003, 2007, 2010, 2016
    Posts
    124

    Re: Columns H is seek help than I want the formula in Columns J to show Fail

    =IF(H5="seek help","fail",IF(H5="pass","pass",""))

    paste the above formula in j5
    Regards,
    abdul

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

    Re: Columns H is seek help than I want the formula in Columns J to show Fail

    Thank you for your help it works very well again thank you Abdul

    Regards
    wykowms

  4. #4
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Doha, State of Qatar
    MS-Off Ver
    excel 2003, 2007, 2010, 2016
    Posts
    124

    Re: Columns H is seek help than I want the formula in Columns J to show Fail

    @wykoems:- my pleasure, happy to help alwayzz.....!

+ 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