Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Percentage
I am a part of a 12 week biggest loser contest. I am trying to create a
spread sheet that will capture the percentage of weight lost each week by just entering the current weeks weight. For example: A B C D Name Starting Wt Week 1 WT Week 1 Loss % And so on for 12 weeks. Is there a formula that would help me out |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Percentage
The below data is in A1:D14 with headers in Row 1
B2 is your starting weight. B3 is for 1st week and so on.. C3 =(B2-B3)/100 and copy the formula down (weekly % loss) D3 =($B$2-B3)/100 and copy the formula down (total % loss) Format Col C and Col D to % style Week Num Weight Weekly % Total % Week0 85.5 Week1 85.3 0.20% 0.20% Week2 85.1 0.20% 0.40% Week3 84.9 0.20% 0.60% Week4 84.7 0.20% 0.80% Week5 84.5 0.20% 1.00% Week6 83.0 1.50% 2.50% Week7 82.5 0.50% 3.00% Week8 82.0 0.50% 3.50% Week9 81.5 0.50% 4.00% Week10 81.0 0.50% 4.50% Week11 80.5 0.50% 5.00% Week12 80.0 0.50% 5.50% -- If this post helps click Yes --------------- Jacob Skaria "Fred Swain" wrote: I am a part of a 12 week biggest loser contest. I am trying to create a spread sheet that will capture the percentage of weight lost each week by just entering the current weeks weight. For example: A B C D Name Starting Wt Week 1 WT Week 1 Loss % And so on for 12 weeks. Is there a formula that would help me out |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Obtaining a Running percentage in a Pivot Table Vlue Zone. | Excel Discussion (Misc queries) | |||
How do I keep a running total of people I contact as a percentage | Excel Worksheet Functions | |||
Need running percentage in pivot table | Excel Discussion (Misc queries) | |||
I need a formula to keep a running percentage....HELP!! | Excel Discussion (Misc queries) | |||
HOW DO I CALCULATE A RUNNING PERCENTAGE | Excel Discussion (Misc queries) |