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.
--
Regards

Roger Govier


"Yaka" wrote in message
...
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
--
Delightfully requesting your assistance , Yaka