subtraction issues
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
|