Calculating percentage
Good day
I want to calculate the percentage of a activities done weekly.
Not be 52 weeks but as per the current week.
That is total of Activities divide by current week.
i want the system to pick the current week Automatically.
=(B7)/(52-B5)*100% == i want to replace the 52 with current week automatically.
Thanks for your assistance
Halla
Last edited by Emekahalla; 07-09-2014 at 12:22 PM.
Try
=B7/(WEEKNUM(TODAY())-B5)
format cell as %
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi
Use this independent formula to calculate the current week and replace it in your formula...
Formula:
Please Login or Register to view this content.
Regards
Vikas Gautam
Say thanks, click *
Thanks a million it works
Can you help me out on this too
Hello
Please how do I use formula in conditional formatting
If B4 is less than 50% as of today , then B4 turn Red.
I want today to be automatic.
Thanks
Hi,
This is a different request so you should start a new thread with an appropriate title. When you do please offer a specific example. If B4 is a number, what are you comparing it to in order to determine whether it's 50%. And furthermore if you're laying down a condition 'as of today' please explain how you expect that to work.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks