LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Formula for subtracting from same number

I'm setting up a "biggest loser" spreadsheet for a group. In one column, I'm
putting in the weight at weigh-in each week. In another column, I want to
keep track of how much has been lost from the original weighin.

So, if I have in cell b2 the first/original weighin, b3 I have the next
weeks weighin, b4 the 3rd week weighin and so on to b53 the last week of the
year. In cell c3 I have the formula =b2-b3 to calculate the weight loss.
Now, in cell c4, I put in =b2-b4 to calculate the total loss in 2 weeks from
the original weight. I can keep going down and manually entering this, but I
want to know if there is a way of "filling down" and keeping the first cell
constant (the b2 original weight) while changing the second number subtracted
being that current weeks weight (b3, b4, b5 etc)
I've tried everything and filling down, I then get b3-b4, b4-b5 instead of
b2-b4, b2-b5.

I hope I haven't confused you!
 
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
Subtracting Text from Number [email protected] Excel Discussion (Misc queries) 6 June 1st 07 10:45 PM
Subtracting Text from Number [email protected] Excel Worksheet Functions 4 June 1st 07 07:02 PM
I need a formula for subtracting from a negative number Pat Excel Discussion (Misc queries) 3 May 26th 07 12:57 PM
subtracting a constant number to all cells in the same column gimianame Excel Discussion (Misc queries) 2 August 11th 05 07:59 PM
Subtracting based on number of miles Ms Chewie Excel Discussion (Misc queries) 3 December 21st 04 05:35 AM


All times are GMT +1. The time now is 12:17 AM.

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

About Us

"It's about Microsoft Excel"