Results 1 to 4 of 4

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

Threaded View

  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:

    =IF(((C5+60)>TODAY()),"DELETE","")
    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

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