Quote:
Originally Posted by DaughteroftheKing
Since I have NO idea what that formula meant, SURE lol... Thank you!
|
All done, and it was no problem at all. Until your first weigh-in, your original weight will appear in the "lbs lost" column, but as soon as you weigh in, it'll change to actual lbs lost.
For those of you who are interested in replicating the formula for yourselves:
What I've done is use the my cell in the AD column (for me 48, for DaughteroftheKing 49) to make a function that is the sum of the losses between all the cells that came before it. (48 is the number of DaughteroftheKing's row; you can replicate what I've done in the final formula just by inputting your own row number.)
SUM=(
In order to show the losses between each week, I've taken each week's cell and subtracted it from the week that came before.
SUM=((B49-C49) shows the loss between DaughteroftheKing's starting weight and her first weigh-in. (C49-D49) shows the loss between the first weigh-in and the second weigh-in, and so on.
Remember your order of operations! Those parentheses are important to make sure all the losses are totaled before we add them all up in cell AD#.
Then, we total all the losses between weeks.
So, DaughteroftheKing's completed cell AD49 function reads SUM=((B49-C49)+(C49-D49)+(D49-E49)+(E49-F49)+(F49-G49)+(G49-H49)+(H49-I49)+(I49-J49)+(J49-K49)+(K49-L49)+(L49-M49)+(M49-N49)+(N49-O49)+(O49-P49)+(P49-Q49)+(Q49-R49)+(R49-S49)+(S49-T49)+(T49-U49)+(U49-V49)+(V49-W49)+(W49-X49)+(X49-Y49)+(Y49-Z49)+(Z49-AA49)+(AA49-AB49))
And that's all there is to it!