Figuring percentages in Excel

[Solved/Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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