+ Reply to Thread
Results 1 to 4 of 4

formula to show Due/Overdue/Achieved

  1. #1
    Registered User
    Join Date
    03-08-2015
    Location
    england
    MS-Off Ver
    10
    Posts
    12

    formula to show Due/Overdue/Achieved

    Hi
    I hope someone can help me with the problem i have .
    I am trying to write formula which will show one of three words in one cell depends on the date from 2 other cells , the words are Due / Overdue / Achieved

    The formula i wrote is :
    PHP Code: 
    =IF(G11="","",IF($I11<TODAY(),"OVERDUE",or IF($I11<=TODAY()-7,"Due",or IF(Q11<=TODAY(),"Achieved")))) 
    I dont know where i am doing it wrong but at the moment its only showing me overdue
    I would be grateful if someone can help me with this.

  2. #2
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: formula to show Due/Overdue/Achieved

    Which one do you want to be evaluated first? If all 3 cells are less than today, which result do you want? Right now your formula is looking at I11 first. If that cell is less than today's date, it will return "Overdue" and stop evaluating the rest of the formula.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.

  3. #3
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: formula to show Due/Overdue/Achieved

    I think this is closer to what you are looking for:
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    03-08-2015
    Location
    england
    MS-Off Ver
    10
    Posts
    12

    Re: formula to show Due/Overdue/Achieved

    Hi Again
    Thank you for support.
    The formula is working but not exactly as i need to be working.
    For some reason the cell I 11 is changing to Due / Overdue and Achieved but only when i am adjusting the start date column

    I did attached the spread sheet which will explain more what i need to do.

    The task i want to achieve is to show the the ( Due / Overdue / Achieved ) in the status column ( J 11 ) based on the condition from
    the Grade due column ( I 11 ) and grade achieved column ( Q 11 )

    So in the normal usage when the person Grade due date will be smaller or equal today date it will show Due but when Due date will be higher that today it will show Overdue and finally when the date from Grade achieved will be smaller or equal that today it will show achieved
    Attached Files Attached Files

+ 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. formula to show if something is up to date, due or overdue.. help!!
    By tahlialouisa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2015, 07:03 AM
  2. Automate Macro script needed to Mark Overdue ,SLA-HOLD,Soon to be Overdue by Hours
    By britishidol200 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-04-2015, 12:55 PM
  3. [SOLVED] Formula for achieved/not achieved percentage
    By chinitapr in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-13-2015, 12:04 PM
  4. [SOLVED] Using IF function to show highest value achieved across a range of cells
    By oatsiebfc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-17-2014, 07:13 PM
  5. excel formula to calculate days result achieved or not achieved
    By breadwinner in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-22-2013, 08:39 AM
  6. [SOLVED] Formula needed to show due / overdue
    By katieshields in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-20-2013, 11:52 PM
  7. Formula to determine total overdue values by length of overdue
    By Midnight_Dragon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 02:03 AM

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