formula for calculating wt gain or loss cumulative in excel

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

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" <Yaka@discussions.microsoft.com> wrote in message
news:00113C79-D311-4BC7-B58F-914FF9CA5372@microsoft.com...
> 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

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?.
--
Delightfully requesting your assistance , Yaka


"Yaka" wrote:

> 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

Check out Tools>Options>Calculation and make sure "Automatic" is checkmarked.


Gord Dibben MS Excel MVP

On Fri, 1 Jun 2007 17:41:00 -0700, Yaka <Yaka@discussions.microsoft.com> wrote:

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