+ Reply to Thread
Results 1 to 4 of 4

SOLVED: Cell that formula is mining data from is empty, want no result

  1. #1
    Registered User
    Join Date
    12-21-2011
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    19

    SOLVED: Cell that formula is mining data from is empty, want no result

    Hello all!

    I have two cells that I am working with: C5 and H5.

    C5 contains a date that I manually enter.
    H5 needs to look at that date and decide wether it is more than 60 days older than the current date. This is the formula that I have for it in cell H5:

    Please Login or Register  to view this content.
    This code does exactly what I need for it to do. The only problem with it is that if there is no date entered into cell C5, H5 displays "DELETE". If there is no data entered into cell C5 I want the cell that the function is in to be empty. How do I do this?

    Thanks in advance for everything!
    Last edited by sourbeer; 01-04-2012 at 10:12 AM. Reason: Problem was solved

  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,420

    Re: Cell that formula is mining data from is empty but formula cell is displaying res

    =IF(C5="","",IF(((C5+60)>TODAY()),"DELETE",""))


    Regards, TMS
    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


  3. #3
    Registered User
    Join Date
    12-21-2011
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Cell that formula is mining data from is empty but formula cell is displaying res

    Quote Originally Posted by TMShucks View Post
    =IF(C5="","",IF(((C5+60)>TODAY()),"DELETE",""))


    Regards, TMS
    Thank you so much! This does exactly what I need for it to do!!!

  4. #4
    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,420

    Re: SOLVED: Cell that formula is mining data from is empty, want no result

    You're welcome. Thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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