+ Reply to Thread
Results 1 to 5 of 5

show blank cell in return without FALSE

  1. #1
    Registered User
    Join Date
    10-21-2014
    Location
    Midwest
    MS-Off Ver
    2000
    Posts
    12

    show blank cell in return without FALSE

    My formula is =IF(G3="x",E3)

    If G3 is not "x" I'd like the cell to show nothing. It now shows "FALSE."

    Gary

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,874

    Re: show blank cell in return without FALSE

    That's because you have omitted the third "value_if_false" argument from the IF() function. To get something other than FALSE, put the desired output into this argument. Recognize that Excel cannot return nothing, but most people use an invisible text string like a space character or empty string "". =IF(G3="x",E3,"")
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    10-21-2014
    Location
    Midwest
    MS-Off Ver
    2000
    Posts
    12

    Re: show blank cell in return without FALSE

    Thanks. To have the cell return E3 only if it has a number of >0?
    So, return E3 if G3 contains an "x" and if E3 is 1,2,3, etc., but if G3 contains an "x" but E3 is 0 then return a blank?

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,874

    Re: show blank cell in return without FALSE

    You understand how the IF() function works, so it is just a matter of combining the logic.

    One way is to combine the "and" logic into a single condition using the AND() function =IF(AND(G3="x",E3>0),E3,"")
    or nest IF() functions to test each condition separately. =IF(G3="x",IF(E3>0,E3,""),"")

    From there you can build nested IF() functions as simple or as complex as you like. It's mostly about keeping track of the logic at each step.

  5. #5
    Registered User
    Join Date
    10-21-2014
    Location
    Midwest
    MS-Off Ver
    2000
    Posts
    12

    Re: show blank cell in return without FALSE

    This is very helpful. I appreciate it. Thanks.

+ 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. Return Cell Values, if blank don't show 0
    By Wiggsy in forum Excel General
    Replies: 2
    Last Post: 10-07-2019, 07:44 AM
  2. Return Blank Cell if value is false
    By Cremorneguy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-02-2014, 11:44 PM
  3. I need my formula to return a blank cell rather than FALSE
    By dnoteman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-07-2014, 03:51 PM
  4. [SOLVED] Return Blank instead of False
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2012, 03:53 PM
  5. [SOLVED] Make a IF formula return a REAL blank cell if false
    By Stildawn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2012, 11:09 PM
  6. Vlookup to return blank cell when false
    By omarq in forum Excel General
    Replies: 5
    Last Post: 11-23-2010, 09:40 AM
  7. How do I create a formula to return a blank cell if false?
    By Vivecat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-28-2007, 07:33 AM

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