+ Reply to Thread
Results 1 to 4 of 4

Adding additional rules to an If function?

  1. #1
    Registered User
    Join Date
    10-14-2022
    Location
    London
    MS-Off Ver
    excel 2016
    Posts
    2

    Red face Adding additional rules to an If function?

    hi everyone,

    firstly this is my first post so apologies if I do anything wrong, I did read the rules so will try my best!

    I am creating a new case tracker for the midwives I work with, I hope you can see the image below, unfortunately due to the data contained in the worksheet I wouldn't be allowed to attach a copy.

    there are several reports they need to write by certain deadlines (e.g. draft at 4 months, final version at 6 months.)

    I created the formula to pre-fill all these dates correctly, but obviously this would be the 'target' date, which is what I have called these columns. I have then added another column to the right, which will calculate if this is 'not due' or 'overdue'.

    this works perfectly and is really helpful, however the cell next to this overdue/not due column would then be where the midwife would be required to input the date they actually submitted the report.

    I wondered if there was a way that I could add to the formula (or maybe I need a different formula all together?) to somehow get the 'overdue/not due' to either clear itself/ change to done once a date has been inputted in the 'actual date completed' column? the main issue is the visual display of 'overdue' for most of the reports when they have obviously been done since.

    My current formula is =IF(ISBLANK(V5),"",IF(V5<TODAY(),"Overdue","Not due"))

    My first thought was I could just add another IF(X6<=TODAY(), "complete") or something to that effect but I am just not good enough at excel to know how to make it work!

    Thanks in advance everyone I really hope this makes sense as I am about to have a stroke with the stress this is causing my brain!

    Excel Help.PNG

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Adding additional rules to an If function?

    Try this:

    =IF(ISBLANK(V5),"",IF(X5<>"","Done",IF(V5<TODAY(),"Overdue","Not due")))

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    10-14-2022
    Location
    London
    MS-Off Ver
    excel 2016
    Posts
    2

    Re: Adding additional rules to an If function?

    thank you so much! this has worked perfectly

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Adding additional rules to an If function?

    You're welcome, and thanks for marking the thread as Solved.

    Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ 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. Adding rules for using keywords
    By Browne in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2021, 01:21 PM
  2. Adding an additional IF function to my existing formula to return a blank
    By xmann21 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-29-2015, 09:52 AM
  3. Need help with a Macro - Adding additional function
    By SalientAnimal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2015, 06:35 AM
  4. Adding additional IF condition
    By dannyjoer in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-28-2014, 10:10 AM
  5. Replies: 4
    Last Post: 04-22-2012, 07:55 AM
  6. Excel 2007 : trouble adding an additional IF function
    By TEdward00 in forum Excel General
    Replies: 1
    Last Post: 07-07-2011, 05:05 PM
  7. Replies: 0
    Last Post: 07-16-2008, 11:03 AM

Tags for this Thread

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