subtraction issues

[wes graham]

OK, I need to keep a record of weight loss, entering one weekly weight
at a time. The only formulas I can find only subtract all the cells at
once. I need to be able to show weekly results, not all ten weeks at
once. Any suggestions?

 

[Bob Bridges]

You can certainly subtract any two numbers you want to. How is your sheet
laid out, and what formulae are you using that subtract all ten weeks at once?

 

[Roger Govier]

Hi Wes

Assuming your weights are in cells A1 for the Start weight, with each
successive weekly weight entered in A2, A3 etc.
In cell B2 enter
=IF(A2="","",A2-A1)
Hover the cursor over the bottom right corner of cell B2 until it becomes a
solid black cross (this is the fill handle
Click on the fill handle with your left mouse key, and hold it down as you
drag down through cells B3:B10
Column B will then show the weekly change in Weight