Microsoft Office excel 2007 home & stude...

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

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. 150In 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 percentageEach 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

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

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.

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.

i dont care about a formula for the goal wt

CURRENT WIEGHT

1-mar 8-mar 15mar so on and so on

390 380 370then 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

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 360use these formulas:

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

In D2: =C2/A2, formatted as Percentage

re: sorry i cant spell somedaysHave 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.

Ask Your Question

Weekly Poll

Do you think Google should sell budget phones in the US?

Discuss in The Lounge

Poll History