formula for calculating wt gain or loss cumulative in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yaka - 01 Jun 2007 05:47 GMT

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

Signature

Delightfully requesting your assistance , Yaka

Reply to this Message

Roger Govier - 01 Jun 2007 11:11 GMT

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.

Signature

Regards

Roger Govier

> I'd like to know how to set up a formula to put my weight in whenever
> in a
[quoted text clipped - 6 lines]
> form
> running vertically. I'm using microsoft Office 2003

Reply to this Message

Yaka - 02 Jun 2007 01:41 GMT

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

Signature

Delightfully requesting your assistance , Yaka

> 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

Reply to this Message

Gord Dibben - 02 Jun 2007 03:39 GMT

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

Gord Dibben MS Excel MVP

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

Reply to this Message