Excel formula for weight loss percentage

Microsoft Microsoft office excel 2007 ac...
January 7, 2010 at 10:54:23
Specs: Windows XP
 HELP!!!I'm setting up a spreadsheet for our weight loss challenge and I need a formula to set up for the cell. I know the formula for figuring your percentage of weight lost, BUT I want to get it into one cell soo all I need to do is enter current weight on each new cell and it gives me the percentageThanks Kyla

See More: Excel formula for weight loss percentage

#1
January 7, 2010 at 12:28:37
 Maybe something like this will get you started:In A1 I entered a value as the starting weight.In B1 I put this formula and formatted it as a percentage:=1-INDIRECT("A"&COUNTA(A:A))/A1As I enter a new weight in A2, then A3, then A4, the percentage shown in B1 will change.The INDIRECT function determines the cell to be used in the calculation by counting the number on entries in Column A, which in essence gives you the Row number of the last entry.For example, with the last entry in A4, there will be 4 pieces of data in Column A and the formula will essentially evaluate to:1-A4/A1You just can't have any blanks in the list. The formula can be modified to fit other layouts, but we'd need to know the exact location of your data before we could make any changes.HTH

Report •
Related Solutions