+ Reply to Thread
Results 1 to 4 of 4

How to show a cell as blank if certain data is showing?

  1. #1
    Registered User
    Join Date
    10-18-2008
    Location
    St John's, Newfoundland, Canada
    MS-Off Ver
    365
    Posts
    88

    Question How to show a cell as blank if certain data is showing?

    Hi all,

    The title might be a little confusing, so hopefully I can explain!

    I have a spreadsheet where one column (E) has a date that a purchase order was created, then another column (H) that has a formula to show how long it has been since that purchase order was created. I am using the following formula in column H, which works great:

    =DAYS360(E2,TODAY())
    =DAYS360(E3,TODAY())
    =DAYS360(E4,TODAY())
    etc
    etc

    The problem I have is that if there is no data/date entered in the cell in column E, then answer to the formula in column H shows as 41049, which I do not want to see! Is there a way of the cells in column H being blank until a date is entered into column E?

    Thanks in advance
    Glenn
    Last edited by gloriousglenn; 01-09-2014 at 11:16 AM. Reason: Solved

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: How to show a cell as blank if certain data is showing?

    =if(e2<>"",DAYS360(E2,TODAY()),"")
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: How to show a cell as blank if certain data is showing?

    hi Glenn. maybe:
    =IF(E2="","",DAYS360(E2,TODAY()))

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  4. #4
    Registered User
    Join Date
    10-18-2008
    Location
    St John's, Newfoundland, Canada
    MS-Off Ver
    365
    Posts
    88

    Re: How to show a cell as blank if certain data is showing?

    Brilliant! It looks like one of those, "It's only easy if you know how" type of things!

    Thanks guys, that worked a treat. Big smiley face here!

+ 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. [SOLVED] If one cell contains #, & other cell is blank, show message & require blank be resolved
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-19-2012, 02:23 PM
  2. show a blank cell if no data in a certain range
    By maztaz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2010, 07:10 AM
  3. 0:00 showing up as blank cell
    By Patronedheart in forum Excel General
    Replies: 2
    Last Post: 04-12-2010, 11:09 PM
  4. 'if' a cell is not having data show it as blank... How?
    By nawshotBO in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-11-2008, 02:38 AM
  5. Cell to show blank until data entered ?
    By conks in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2008, 09:12 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