I am a part of a 12 week biggest loser contest. I am trying to create a
spread sheet that will capture the percentage of weight lost each week by
just entering the current weeks weight.

For example:

A B C D
Name Starting Wt Week 1 WT Week 1 Loss % And so on for 12
weeks.


Is there a formula that would help me out