Hi Smartin
You're right, the best is the simplest one you got =B1-A1.
When it's to easy you always look further then needed.
But that's the way we get better.
All the Best
John
"smartin" wrote in message
...
Will give incorrect result if a person has a weight gain instead of a
loss. Alas, it happens to the best of us!

John wrote:
HI
With this formula in B2 =MAX(A$1:B$1)-MIN(A1:B1) and copy along to F2, i
get the result you see below.hoping this is what you're looking for.
A1 B1 C1 D1 E1 F1
200 196 190 188 175 164
4 6 2 13 11
HTH
John

"ericaamousseau" wrote in
message ...
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!