Hi,

I would suggest that go on fillling the data from A1 to L1 and in M1 type
the formula
=A1-L1 this will give an answer for a complete course of weight loss. Say in
this case the course would be of 3 months i.e 12 weeks
Now divide the figure you got in M1 i.e M1/12 this will give you the weight
loss data per week.

Even if the person lossing or gaining during the course it makes no
difference cause you are looking for only two values one is the start value
and 2nd is the end value.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"ericaamousseau" wrote:

I was not sur if there was a way to have a formula move cells as you type. I
am not explaining it right, but say I have a spreadsheet for weight loss for
a group of people if the begginging weight is in cell A1 and the next week's
weight is in B1 and week after that is in C1 can I have the subtraction
"follow" the numbers to show weight lost each week? :

A1 B1 Formula
196 194 2

next week would be

A1 B1 C1 Formula
196 194 190 4

So that when I typed in C1 the formula shifted so as to ignor A1 and
subtract C1 from B1. Is this possible? thanks!