View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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