+ Reply to Thread
Results 1 to 13 of 13

Automatical Formula

  1. 03-14-2018, 08:43 AM #1
    chillern1
    chillern1 is offline
    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
    Reply With QuoteRegister To Reply
  2. 03-14-2018, 08:52 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    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



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 03-14-2018, 08:53 AM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    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.
    Reply With QuoteRegister To Reply
  4. 03-14-2018, 08:56 AM #4
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,152

    Re: Automatical Formula

    Removed by Jt
    Reply With QuoteRegister To Reply
  5. 03-14-2018, 08:57 AM #5
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,152

    Re: Automatical Formula

    Awaiting title change!
    Reply With QuoteRegister To Reply
  6. 03-14-2018, 09:08 AM #6
    chillern1
    chillern1 is offline
    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
    Reply With QuoteRegister To Reply
  7. 03-14-2018, 09:20 AM #7
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Automatical Formula

    Maybe:

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

    please do not duplicate threads!!!
    Reply With QuoteRegister To Reply
  8. 03-14-2018, 09:26 AM #8
    chillern1
    chillern1 is offline
    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?
    Reply With QuoteRegister To Reply
  9. 03-14-2018, 09:29 AM #9
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Automatical Formula

    Just don't start any more!!!
    Reply With QuoteRegister To Reply
  10. 03-14-2018, 09:37 AM #10
    chillern1
    chillern1 is offline
    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"
    Reply With QuoteRegister To Reply
  11. 03-14-2018, 09:47 AM #11
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Automatical Formula

    Try:

    ther formula in the sheet. The site won't let me post the formula here!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 03-14-2018, 09:52 AM #12
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Automatical Formula

    Withdrawn by lln...
    Last edited by leelnich; 03-14-2018 at 09:54 AM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
    Reply With QuoteRegister To Reply
  13. 03-14-2018, 09:59 AM #13
    chillern1
    chillern1 is offline
    Registered User
    Join Date
    03-14-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    39

    Re: Automatical Formula

    Thank you it works
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. [SOLVED] how can I make a table of worksheet names that updates automatical
    By nah in forum Excel General
    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. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1