Forum Discussion
Solved
Help please - Time elapsed as percentage with 100% cap and no negative values
Hi all, I have the below table: I would like the Percent Completed column to show the time elapsed as a percentage, but with the following features: Capping at 100% for tasks wh...
The formula that I posted was for row 4 (as I mentioned), not for row 2.
I have attached a version with structured table references.
In G4:
=IF(OR(C4="",D4=""),"",MIN(MAX((TODAY()-C4+1)/(D4-C4+1),0%),100%))
Format as a percentage and fill down.
HansVogelaar I'm afraid that's not working - I'm getting 100% in some tasks not started or with dates in the future
Could you attach a small sample workbook demonstrating the problem, without sensitive information?
