+ Reply to Thread
Results 1 to 6 of 6

Formula to determine if action overdue

Hybrid View

MGK Formula to determine if... 01-11-2012, 08:12 AM
Richard Buttrey Re: Formula to determine if... 01-11-2012, 08:30 AM
MGK Re: Formula to determine if... 01-11-2012, 09:24 AM
MGK Re: Formula to determine if... 01-11-2012, 10:51 AM
Richard Buttrey Re: Formula to determine if... 01-11-2012, 10:59 AM
MGK Re: Formula to determine if... 01-11-2012, 11:21 AM
  1. #1
    Registered User
    Join Date
    10-13-2011
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    13

    Formula to determine if action overdue

    Hi,

    I'm trying to create a formula to determine if an action is overdue. If RAR is open and it does not have an action created or it does have an action created and the due date is before today then "overdue", otherwise "in process".

    I have tried this but it is not being recognised as a formula. I've not yet attempeted to include the "in process" part

    IF(O2="OPEN"&(T2="NO"),IF(T2="YES"&U2<TODAY),"OVERDUE")

    O is RAR Status
    T is Action created
    U is Due date

    Can someone point out where I'm going wrong?

    Thanks

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula to determine if action overdue

    Hi,

    Try
    =IF(OR(AND(O2="OPEN",T2="NO"),AND(T2="YES",U2<TODAY())),"OVERDUE","In Process")
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    10-13-2011
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Formula to determine if action overdue

    Thank you for such a speedy and effective response, that seems to have worked a treat.

  4. #4
    Registered User
    Join Date
    10-13-2011
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Formula to determine if action overdue - additional condition

    Wouldn't you know it. I've been asked to put an additional condition into the formula. My chap now wants to insert if T2 = null then overdue. I have tried adding (T2="") into various places in the formula supplied, both with and without AND but where ever I put it I get an error message. I'd be really grateful for help with this, and I really appreciate the help I have already received.

    =IF(OR(AND(O2="OPEN",T2="NO"),AND(T2="YES",U2<TODAY())),"OVERDUE","In Process").

    Thanks

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula to determine if action overdue - additional condition

    Try

    =IF(OR(AND(O2="OPEN",T2="NO"),AND(T2="YES",U2<TODAY()),T2=""),"OVERDUE","In Process")

    Regards

  6. #6
    Registered User
    Join Date
    10-13-2011
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Formula to determine if action overdue

    Thank you once again Richard for coming to my rescue. Hopefully that will satisfy what he needs. You are a star.

+ Reply to Thread

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