+ Reply to Thread
Results 1 to 13 of 13

Automatical Formula

  1. #1
    Registered User
    Join Date
    03-14-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    39

    Automatical Formula

    Hello,

    I prepared an excel sheet with an example of my problem.
    Indeed I have almost the correct formula. I marked the problems red and added a comment. G26 has to be "Not started", because the Start Date is in the future. E25 has to be blank, because the due date is blank.

    Can someone help me?
    Thanks in advance.
    Marie
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,596

    Re: Automatical Formula

    Try this. However, your explanation is not clear. What makes for an "ongoing" result?

    =IF(A12>TODAY(),"Not started",IF(C12="","","Closed"))
    Glenn



  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,596

    Re: Automatical Formula

    I have just noticed the title of your thread. It is meaningless. Please go back to post 1, select thread tools and amend the title to something that you might use as search terms in google.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,779

    Re: Automatical Formula

    Removed by Jt

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,779

    Re: Automatical Formula

    Awaiting title change!

  6. #6
    Registered User
    Join Date
    03-14-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    39

    Re: Automatical Formula

    Excuse me but I am new and I don't really know how to change the title. I am German, so their could be some language barrier. Nevertheless, I hope that you understand me.

    On going should be when: Start date is => Today
    Closed: End date >= Today
    Not started: Start date < Today

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,596

    Re: Automatical Formula

    Maybe:

    =IF(A12>TODAY(),"Not started",IF(AND(A12<>"",A12<=TODAY(),D12=""),"Ongoing",IF(C12="","","Closed")))

    please do not duplicate threads!!!

  8. #8
    Registered User
    Join Date
    03-14-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    39

    Re: Automatical Formula

    I don't know how to delete one of them!!! Maybe someone could tell me?

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,596

    Re: Automatical Formula

    Just don't start any more!!!

  10. #10
    Registered User
    Join Date
    03-14-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    39

    Re: Automatical Formula

    Okay, I won't.

    Thank you for the help. The formula seems almost correct. But one problem still remains: If the due date is empty and the end date is in the past, the status should be "Closed"

  11. #11
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,596

    Re: Automatical Formula

    Try:

    ther formula in the sheet. The site won't let me post the formula here!!
    Attached Files Attached Files

  12. #12
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: Automatical Formula

    Withdrawn by lln...
    Last edited by leelnich; 03-14-2018 at 09:54 AM.
    Clicking the Add Reputation star below any helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion. (Thread Tools above Post # 1) Thanks!-Lee

  13. #13
    Registered User
    Join Date
    03-14-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    39

    Re: Automatical Formula

    Thank you it works

+ 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. Automatical setting of conditional formating
    By jj4jj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2016, 04:36 PM
  2. [SOLVED] automatical track the number of new work orders per month
    By mmccra2858 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2014, 03:17 PM
  3. Generating an automatical email to outlook from excel based on date
    By gurj_sandhu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2008, 06:53 AM
  4. Replies: 4
    Last Post: 08-22-2006, 07:55 PM
  5. [SOLVED] can any one tell me how to convert figures into words automatical.
    By viral_pandya_virurids in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-03-2006, 01:45 PM
  6. How do I get ONLY new info from 1 Worksheet to another automatical
    By Elaine in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-13-2006, 12:50 PM
  7. Is it a way to schedule an excel spreadsheet to update automatical
    By Jeff in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-31-2005, 03:05 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