I'm looking for a formula I can use in excel that will track weight loss. I want to take the current week's weight and have it subtracted from the original weight. The spreadsheet will cover 52 weeks of weigh ins. How can I create a formula that will use the last weight entry compared to the original weight entry every week? Any help is appreciated. Thank you.
Hi,
You need to make the reference to the cell containing the original weight absolute. You can do this by adding dollar signs. eg
intead of A1, use $A$1
You can then copy and paste the formula without the absolute value changing.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Sorry Dave...how do i complete the rest of the formula?
OK,
so you put the original weight in A1,
Then in A2 to A52 you put the relative week's weight
In B2 enter
=$A$1-B1
which will give you the loss of weight for that week.
Copy B2 and paste it into B3:B52
Is there a way to do that so it tracks to date instead of having it track for each week? I hope i'm making sense...lol.
So you just want the original weight minus the lastest weight recorded?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks