+ Reply to Thread
Results 1 to 2 of 2

Cell referenced in formula has no information displayed (shows blank), return blank cell

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    Syracuse, NY
    MS-Off Ver
    Excel 2010
    Posts
    2

    Cell referenced in formula has no information displayed (shows blank), return blank cell

    I have attached a fake spreadsheet to better explain.

    If F2 displays no information (shows blank) , I need G2 to display no information (show blank).

    The formula in column G is =IF(F2<=365,"1 year or less",(IF(AND(F2>=366,F2<=720),"2 years",(IF(AND(F2>=721,F2<=1095),"3 years",(IF(AND(F2>=1096,F2<=1460),"4 years",IF(F2>=1825,"5 years or more",""))))))))

    I have tried =IF(ISBLANK(formula),"",formula). It still returns "5 years or more" in colum G, even if the referenced F cell is blank. I think my problem is that column F isn't really blank, it is just returning or displaying a blank cell based on the formula is column F.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Re: Cell referenced in formula has no information displayed (shows blank), return blank ce

    Try this
    =IF(F2="","",[Formula])
    Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.

    Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
    If you're happy with an answer given, please click the * under the person's name to boost their reputation.

+ 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. Index/ Match Formula, How to return blank cell as a blank not 0
    By MDResearcher in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-24-2016, 08:40 PM
  2. If formula to return blank if reference cell blank
    By dhooper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-10-2013, 08:56 PM
  3. [SOLVED] Need formula to return blank instead of #N/A when source cell is blank, using VLOOKUP
    By TMB1234 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2013, 07:16 PM
  4. Replies: 5
    Last Post: 03-23-2011, 07:09 PM
  5. Blank cell shows 0 or 12:00 AM if there is formula
    By fun123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-25-2009, 03:38 PM

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