Results 1 to 10 of 10

Formula: If cell 3 is blank have cell 1 calculate, if cell 3 filled have cell 2 calculate

Threaded View

  1. #1
    Registered User
    Join Date
    05-24-2014
    Posts
    34

    Formula: If cell 3 is blank have cell 1 calculate, if cell 3 filled have cell 2 calculate

    Bare with me, I am not sure the best way to word this.

    Currently column I(uncompleted) calculates days between current date and whichever date is later between columns E(Scheduled) and F(Arrived).
    I would like column I(uncompleted) to continue doing this unless there is a date in column K(Notification).
    Once there is a Date in column K(Notification) I would like column I(uncompleted) to become blank and then I would like column J(completed) to calculate days between column K(Notification) and the later date between Columns E(Scheduled) and F(Arrived).

    Attached is an example that I hope will help you all to understand what I am wanting to do.

    Let me know if you need more info to help clarify it more.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF Cell is blank, calculate, if cell isn't blank, leave blank
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2015, 03:54 PM
  2. 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
  3. Replies: 0
    Last Post: 08-14-2012, 10:42 AM
  4. Formula to calculate if cell A* is the first non-blank, then...
    By galaxy_madness in forum Excel General
    Replies: 7
    Last Post: 11-25-2011, 04:30 PM
  5. Move filled cell to right and insert blank cell
    By Chemistification in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-18-2011, 08:39 AM
  6. Find Last Filled Cell In Column And Calculate
    By sratkins in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-06-2011, 01:50 PM
  7. Replies: 9
    Last Post: 03-23-2010, 02:07 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