Hi all,
I am not an expert in EXCEL, and I am having issue on the following.
I have this formula that calculate a % with a status bar:
=(MIN(TODAY();S62)-A62+1)/(S62-A62+1)
I would like to add that if this % is 100%, it show the written COMPLETED, but I struggling to do that.
Thanks, regards
Carlo
Bookmarks