formula for calculating wt gain or loss cumulative in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to know how to set up a formula to put my weight in whenever in a
cell and have excel tell me if its a gain or loss and have it doing it
cumulative. Example If I weigh 120 and the next time I put in a weight I'm
122 the answer says 2 then the next time I put in 124 the answer would be 4
then the next time I put in 123 the answer would be 3 etc. in chart form
running vertically. I'm using microsoft Office 2003
 
Hi

If you put your start weight in A1, and then your subsequent weights in
cells below this, from A2 onward, then in cell B2
=IF(A2="","",A2-$A$1)
Copy down column B as far as required.
The cells in column B will remain blank, until there is a corresponding
value in column A.
 
lRoger, thank you so much... the formula works . however when I copy down
column B the original weight I put in the formula copies all the way down.
What did I do wrong?.
 
Check out Tools>Options>Calculation and make sure "Automatic" is checkmarked.


Gord Dibben MS Excel MVP
 
Back
Top