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?

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?

--- "wes graham" wrote:
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?

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
--
Regards
Roger Govier

"wes graham" wrote in message
...

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?




--
wes graham