+ Reply to Thread
Results 1 to 4 of 4

Return Blank Cell if value is false

  1. #1
    Forum Contributor
    Join Date
    07-30-2014
    Location
    Mosman, Australia
    MS-Off Ver
    2013
    Posts
    118

    Return Blank Cell if value is false

    Hi there,

    I'm using a formula which is getting details from three columns, however there is a point where its returning #VALUE!

    So my sheet looks like this:

    Column O & P:
    Country Names (O) and City Names(P)

    Column Z:
    I only enter the letter X in all the cells of the whole column.

    Column AJ:
    Uses the following formula;
    Please Login or Register  to view this content.
    Column AU:
    Just equals the value from column AJ

    At the moment, column AJ is showing #VALUE! when there is an "X" in column Z but theres no data in either column O or P.

    Not using conditional formatting as that wont help with what i want to do, how do i get the cell to return blank instead of #VALUE!
    ??

    Many thanks

  2. #2
    Forum Contributor
    Join Date
    05-04-2014
    Location
    New Jersey, United States
    MS-Off Ver
    Excel 2010, 2013
    Posts
    120

    Re: Return Blank Cell if value is false

    Try this:

    =IFERROR(IF(R4="x",("- ")&$O4&$P4,""),"")

    or

    =IF(ISERR(R4="x"),"",("- ")&$O4&$P4)

  3. #3
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Return Blank Cell if value is false

    Try this..
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  4. #4
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Return Blank Cell if value is false

    Your formula not supposed to give error , Pl post a sample in excel file

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click just below left if it helps, Boo?ath?

+ 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. 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
  2. [SOLVED] Return Blank instead of False
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2012, 03:53 PM
  3. [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
  4. Vlookup to return blank cell when false
    By omarq in forum Excel General
    Replies: 5
    Last Post: 11-23-2010, 09:40 AM
  5. 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