Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 3
Default 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
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: formula for calculating wt gain or loss cumulative in excel

Hi Yaka,

Sure, I can help you with that! Here's how you can set up a formula to calculate your weight gain or loss in Excel:
  1. First, you'll need to decide on a starting weight. Let's say your starting weight is 120 pounds.
  2. In the cell next to your starting weight (let's say it's cell A2), enter the formula "=0". This will be your starting point for calculating weight gain or loss.
  3. In the cell next to your first weight entry (let's say it's cell B2), enter the formula "=B2-A2". This will calculate the difference between your first weight and your starting weight.
  4. Copy the formula in step 3 and paste it into the cell next to each subsequent weight entry. Excel will automatically adjust the formula to calculate the difference between each weight entry and the starting weight.
  5. To make the formula cumulative, you'll need to use a running total formula. In the cell next to your first weight entry (let's say it's cell C2), enter the formula "=B2". This will show your weight for that entry.
  6. In the cell next to your second weight entry (let's say it's cell C3), enter the formula "=C2+B3". This will add the weight difference from your second entry to your weight from your first entry, giving you a running total.
  7. Copy the formula in step 6 and paste it into the cell next to each subsequent weight entry. Excel will automatically adjust the formula to calculate the running total for each entry.
  8. To make the chart, select the cells with your weight entries and running total formula, then click on the "Insert" tab and select the chart type you want to use. You can customize the chart as needed.

That's it! Now you can enter your weight in each cell and Excel will calculate your weight gain or loss and show you a running total in chart form.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2,886
Default formula for calculating wt gain or loss cumulative in excel

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



  #4   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 3
Default formula for calculating wt gain or loss cumulative in excel

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

  #5   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default formula for calculating wt gain or loss cumulative in excel

Check out ToolsOptionsCalculation and make sure "Automatic" is checkmarked.


Gord Dibben MS Excel MVP

On Fri, 1 Jun 2007 17:41:00 -0700, Yaka 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?.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weight Gain Loss JoeMNY Excel Discussion (Misc queries) 3 December 31st 06 10:32 PM
Excel formula to calculate % gain when adding cash equity to accou Anita Excel Worksheet Functions 0 April 29th 06 04:19 PM
does anyone have a chart for weight gain or loss in kilos? Robynr Excel Discussion (Misc queries) 3 January 9th 06 12:01 PM
Excel Template to track Gain/Loss for IRS purposes BogueBanks Excel Discussion (Misc queries) 0 April 7th 05 07:27 PM
Spreadsheet to do annual investment gain$, % gain, for list notaspreadsheetgenius Excel Worksheet Functions 0 January 9th 05 07:51 AM


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"