+ Reply to Thread
Results 1 to 2 of 2

Leave cell blank if referenced cell and/or formula is blank or incomplete

  1. #1
    Registered User
    Join Date
    12-05-2010
    Location
    Tijuana
    MS-Off Ver
    Excel 2010
    Posts
    10

    Leave cell blank if referenced cell and/or formula is blank or incomplete

    The Dates in Process column is populated by subtracting the Date created from the completed date in order to get the total number of days. However when an item is not completed and there is no completed date, the Dates in Process is populated with a -4thousand number . I would want for the cell to be blank if there is no completed date entered in that row.
    That goes the same for the lead time which is computed by subtracting the Date created from the InWork Date (gets crazy when there is no Inwork Date.

    Also, for future reference I created a column that extracts the month in which an item was completed (from Completed Date Column) using =TEXT([@[Completed Date]],"mmmm")


    However, when there is no Completed Date the Month displayed is January , which should be blank. How can I fix these things?
    Attached Images Attached Images

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,336

    Re: Leave cell blank if referenced cell and/or formula is blank or incomplete

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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] Returning a blank in a cell if the referenced cell is blank (with a formula) itself
    By milkychips in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2016, 08:57 AM
  2. Replies: 10
    Last Post: 09-12-2015, 02:04 PM
  3. Calculate differnce between 2 dates, but if 1 date cell is blank leave cell blank
    By Vicious00013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2014, 11:31 PM
  4. Leave cell result blank if blank cell is in formula
    By Grind in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 09-28-2013, 06:15 AM
  5. [SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell
    By nunayobinezz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2013, 04:51 PM
  6. Leave a formulated cell blank until referenced cell has a value
    By jasemoy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-15-2011, 03:39 AM
  7. [SOLVED] Formula that will leave cell blank if cell is blank
    By jimtmcdaniels in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2006, 02:30 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