Hi There,
Please could you help me with a formula based on % complete and dates.
In column A i need to show the current status';
Overdue - not 100% and passed finish date.
In progress - not 100% but not passed finish date.
Complete, task is 100% complete.
Thanks all.
Try this formula see column A
MOD EDIT: =IF(C2=1,"Complete",IF(AND(C2 < 1,E2 > TODAY()),"In progress",IF(AND(C2 < 1,E2 < TODAY()),"Overdue")))
Last edited by AliGW; 11-04-2021 at 06:45 AM.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
@Keebellah
PLEASE also post formulae in the body of your post. Some people won't be able to access attachments! Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you,
I forgot to mention that if percentage is less than zero then it has "not started".
Help please
I got a server error and the text was lost to me that's why I added the attachment, I don't see where you got the MOD EDIT form.
It's ok i figured it out.
You see, it's not that I didn't want to tell you but it's better to find it yourself, the logic with formulas aside from the functions knowledge is simple and straight forward, it's always true or false whatever you do in them
From the workbook you posted.Originally Posted by Keebellah
When you have < or > in a formula, you have to add spaces either side of them, otherwise you get that error message when trying to post.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
@AliGW: I thought of that since it is interpreted as HTML code but I just didn't think of a space, once again, never too old to learn
Thanks Ali
Last edited by Keebellah; 11-04-2021 at 11:11 AM. Reason: type-oooo
@TDFrench: I modified the formula with what you said and noticed a minor correction was needed too.
It looks complete now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks