wieght lose formula

Microsoft Office excel 2007 home & stude...
August 11, 2010 at 13:48:45
Specs: Windows XP
i am trying to write a formula in excel that calculates percetage lost. this is how i have the sheet setup.
starting wieght, total lost, percentage lost, then the next blocks will be for when i wiegh my self. trying to do a formula where it shows how much lost also


See More: wieght lose formula

Report •

#1
August 11, 2010 at 19:21:47
Your didn't say whether your data was in rows or columns so I'll toss out a suggestion and you can rearrange it as you like.

I am also assuming that you want to record/save your actual weight each time you way yourself:

150
145
142
138
etc.


In A1, enter the text Current Weight
In A2, enter your starting weight, e.g. 150

In B1, enter the text Total Lost
In B2, enter this formula:

=A2-OFFSET(A2, COUNTA(A3:A1000), 0)

In C1, enter the text Percent Lost
In C2, enter =B2/A2 and format the cell as a percentage

Each time you weigh yourself, enter it in Column A. First in A3, then in A4, then in A5, etc.

The formula in B2 will use the COUNTA function to count how many entries are in A3:A1000 and use that number as the rows argument for the OFFSET function.

The OFFSET function will grab the last value (weight) in the list and subtract it from the Starting Weight in A2.

The formula in C2 will calculate the Percentage lost.


Report •

#2
August 11, 2010 at 19:38:56
it is set up in a row. there are going to be multiple people on this spread sheet
STARTING WIEGHT GOAL WIEGHT TOTAL LOST % lost CURRENT WIEGHT
this is how it is set up but under current wieght there will be a place to put the wieght each week or so that they have lost.

Report •

#3
August 11, 2010 at 20:49:39
So the setup you told us about in your first post was wrong?

There was no mention of GOAL WIEGHT.

BTW, it's weight, not wieght.

When you say:
under current wieght there will be a place to put the wieght each week or so that they have lost.

Do you mean that each week they will put the new weight in the same cell or do you mean that they will put the new weight at the bottom of a list.

Do you mean that they will put their actual weight in the cell(s) or do you mean that they will calculate how much they've loss and just enter the amount lost?

Keep in mind that we can't see your spreadsheet from where we're sitting nor can we read minds. Unless you are perfectly clear about how your spreadsheet will be laid out and used, we can't offer any specific solutions.



Report •

Related Solutions

#4
August 12, 2010 at 11:45:48
i dont care about a formula for the goal wt
CURRENT WIEGHT
1-mar 8-mar 15mar so on and so on
390 380 370

then under the total lost colomn i would like a formula to calculate the total wt lost so far
i hope ths clears it up for ya sorry i cant spell somedays


Report •

#5
August 12, 2010 at 12:21:45
The concept of the solution I offered in my first response will work for you once you change it to work across a row vs. down a column.

With this set up...

      A	       B        C        D       E       F       G
1  STARTING   GOAL     TOTAL      %
    WIEGHT   WIEGHT    LOST     LOST   1-Mar   8-Mar   15-Mar
2    390      175       30       8%     380      370    360

use these formulas:

In C2: =IF(E2<>0,A2-OFFSET(D2,0,COUNTA(E2:IV2)),0)
In D2: =C2/A2, formatted as Percentage


Report •

#6
August 12, 2010 at 16:47:23
re: sorry i cant spell somedays

Have you ever heard of a Spell Checker? Or a shift key? Or an apostrophe?

Come on...have just a little pride in how you present yourself to the world.


Report •

Ask Question