Weight tracking formula?
 

I am attempting to keep track of my weight loss/gain and don't know how to
write the formula so that I can tally each week the total loss/gain.

Weight tracking formula?
 

Marilyn wrote:
I am attempting to keep track of my weight loss/gain and don't know
how to write the formula so that I can tally each week the total
loss/gain.


I think that here you can find some useful template:

http://office.microsoft.com/en-us/te...482871033.aspx

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Weight tracking formula?
 

Marilyn,

Here is one way

In A1 put total last or gained
A2 Date
B2 weight
C2 Change
Starting in A3 you will put the date
B3 your weight
In C1 put =SUM(C4:C200)
In C4 put =IF(ISBLANK(B4),"",B4-B3)
Fill this formula down to C200
Column C will give you the change from date to date and C1 will give you the
total lost or gained


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Marilyn" wrote in message
...
I am attempting to keep track of my weight loss/gain and don't know how to
write the formula so that I can tally each week the total loss/gain.