shornbuckle
New Member
- Joined
- Aug 23, 2024
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi - I need a formula that will show me a projection's percentage complete at year end. Every formula I find only shows completion through today.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Completion at Year End Formula
- Thread starter shornbuckle
- Start date
shornbuckle
New Member
- Joined
- Aug 23, 2024
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Well I wasn't expecting it to be this complicated until I plugged in the initial formula and these issues appeared. Thanks for your help.
Upvote
0
Excel Facts
Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,140
- Office Version
- 365
- Platform
- Windows
You are welcome. Glad we were able to help!
We see that you are new here, so we are just trying to give you some tips on how to get the best help as fast as possible.
Visual aids are usually extremely helpful, as they show us what your data looks like, how it is structured on your sheet, etc. (you know the old saying, "a picture says a thousand words!").
When presenting the examples and expected results, it is usually helpful to try to think and present all different scenarios you can think of. Many times people get in trouble when they try to "oversimplify" things, and then they get replies that answer the exact question that they posted here, but does not work for them in reality because their situation is more complex than the simple example. So I usually tell people not to oversimplify things for our sake. Try to post your question as it really pertains to you in your environment.
Good luck and happy excel-ling!
We see that you are new here, so we are just trying to give you some tips on how to get the best help as fast as possible.
Visual aids are usually extremely helpful, as they show us what your data looks like, how it is structured on your sheet, etc. (you know the old saying, "a picture says a thousand words!").
When presenting the examples and expected results, it is usually helpful to try to think and present all different scenarios you can think of. Many times people get in trouble when they try to "oversimplify" things, and then they get replies that answer the exact question that they posted here, but does not work for them in reality because their situation is more complex than the simple example. So I usually tell people not to oversimplify things for our sake. Try to post your question as it really pertains to you in your environment.
Good luck and happy excel-ling!
Upvote
0
