Figuring percentages in Excel

Solved/Closed
mt - Jan 26, 2010 at 12:02 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 29, 2010 at 09:40 PM
Hello, we are doing a weight loss contest and trying to figure out a formula to do the math. We need a formula that will figure the cumulative pounds lost or gained and the cumulative total percentage of bodyweight lost or gained. Thanks for your help!

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jan 29, 2010 at 09:40 PM
presuming your sheet look like this

Col A Col B COL C
WEEK LOSS
week 1 -10
week 2 -14
week 3 0
week 4 1


you can use in Col C formula as

=IF(ISNUMBER(C1),C1+B2,B2)

Col A Col B COL C
WEEK LOSS Week Cumm
week 1 -10 -10
week 2 -14 -24
week 3 0 -24
week 4 1 -23
0