+ Reply to Thread
Results 1 to 4 of 4

Keeping cells blank if no data entered in trigger cell

  1. #1
    Registered User
    Join Date
    04-21-2015
    Location
    Charleston, SC
    MS-Off Ver
    Office for Mac 2011
    Posts
    4

    Keeping cells blank if no data entered in trigger cell

    I have a simple question. I have a timeline that is triggered by an original date cell. The formula works well, but when I don't have a date filled in, the triggered cells still show dates, and I want them to remain blank but with the formula intact (i.e. hidden unless an entry has been made to the first cell). Any ideas?

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Keeping cells blank if no data entered in trigger cell

    Try something like this...

    =IF(A1="","",your formula here)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    04-21-2015
    Location
    Charleston, SC
    MS-Off Ver
    Office for Mac 2011
    Posts
    4

    Re: Keeping cells blank if no data entered in trigger cell

    Thank you that worked beautifully!

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Keeping cells blank if no data entered in trigger cell

    You're welcome. Thanks for the feedback!

+ 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] Keeping a cell blank if the related cells shows
    By Anuru in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-24-2014, 05:27 AM
  2. [SOLVED] Blank formula cells until data is entered?
    By DarkSoul in forum Excel General
    Replies: 13
    Last Post: 07-27-2014, 09:18 AM
  3. Keeping cells blank until data is entered?
    By mikeuk1954 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-27-2013, 03:48 PM
  4. How to color-fill blank cells, then once data is entered cell is no-fill
    By hatemail13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-28-2013, 07:57 PM
  5. Replies: 2
    Last Post: 02-22-2013, 04:24 PM
  6. [SOLVED] Need Help Keeping Cells Blank Until Data is placed in Input Cell
    By areidel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-19-2012, 05:45 PM
  7. Keeping Blank Cells Until Data Entered
    By msf316 in forum Excel General
    Replies: 3
    Last Post: 02-27-2009, 03:55 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