Good afternoon,
I am trying to calculate the percent change question. I know the basics of calculating the percent change (new-old/old). what I'm trying to do is find th percent change from a starting weight and the most recent weight.
What i have is a column with the weights entered
In Column B1
175
174.3
173
174
172.8
170.3
169
169.5
166.2
What i need to do is calculate the percent change ion the first and last cells as they are entered weekly so can give updates. i need it to automatically use the latest data entered.
Any help would be greatly appreciated.
TIA
Los
Bookmarks