+ Reply to Thread
Results 1 to 10 of 10

IF_true/false

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: IF_true/false

    hi cicihk

    first the match function is giving the column numbre if Fail is found in the range. that number >0 will give result true if there is a fail in the range.

    an if true if function give result "Fail"

  2. #2
    Registered User
    Join Date
    11-14-2010
    Location
    HK
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: IF_true/false

    Quote Originally Posted by Azam Ali View Post
    hi cicihk

    first the match function is giving the column numbre if Fail is found in the range. that number >0 will give result true if there is a fail in the range.

    an if true if function give result "Fail"
    Azam Ali,
    ic. will it be ok if I omit ">0" in the function?

+ 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