Prev: Paste Special and Paste Object
Next: Payroll
From: angel5959 on 26 Jan 2006 12:45
We're having a weight loss competition at work and I'm trying to set up a
table that will show each persons weight each week, total loss/gain and
percentage of loss. Can anyone help me?
From: vezerid on 26 Jan 2006 13:02
Assuming the weekly weights of a single person are in a column (say in
A2:A10), the formulas:

=A3-A2
=(A3-A2)/A2

will show respectively the net weight change and percent change
(negative values indicate loss. These formulas should be placed in row
3 and can be copied down.

HTH
Kostis Vezerides

From: BekkiM on 26 Jan 2006 13:10
Set up a table like this:
A B C D E X
1 Name Total Percent Start Week 1 Week #

In Cell B2: =D2-OFFSET(D2,0,COUNTA(D2:X2)-1)
In Cell C2: =B2/D2
Copy these formulas down for as many participants as you have.

List out all of your weeks and just enter the official weights each week.
Just make sure that "X" in the formula above is the column letter of your
last week (Figure a year's worth of weeks from the start--you should be good
to go)

Good luck!

"angel5959" wrote:

> We're having a weight loss competition at work and I'm trying to set up a
> table that will show each persons weight each week, total loss/gain and
> percentage of loss. Can anyone help me?
 | 
Pages: 1
Prev: Paste Special and Paste Object
Next: Payroll