+ Reply to Thread
Results 1 to 3 of 3

True/False Function, ignore blank

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

    True/False Function, ignore blank

    my question is: if I use a true / false function:

    H10 =if(G10>$G$1,"Pass","Fail")
    H11 =if(G11>$G$1,"Pass","Fail")


    However, if G11 is a blank cell, it returns "Pass" on H11, but actually it is a blank cell
    How do I tell the function to ignore blank cell (G11) and gives me a return of blank cell (H11)?

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,036

    Re: True/False Function, ignore blank

    Try:

    =IF(G11="","", IF(G11>$G$1,"Pass","Fail"))
    Never use Merged Cells in Excel

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

    Re: True/False Function, ignore blank

    zbor, It works fine..Thank you so much.

+ 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