Convert weight loss numbers into percent

[cefa]

Hi!

I'm new here but do know a bit about Excel, an average user maybe. Have even taken some classes to get better.
But I have hit a dead end and need some help.

Me and a few colleagues felt that we needed to loose some weight after all the christmas and new years food so we put together a competition between us.
It will go on for several weeks and I wanted to make a diagram of everybody's weight loss, both in pure numbers but also in percent of start weight.

Let me show you what i mean.

weight (kilo)	%
92	100
89	?
88	?
85	?
81	?

As you can see in the table above we have the weight input every week in the left column (A). These are the numbers i punch in every week after we done our weekly weigh-in.
In the right column (B) I want to show the weight loss in percent.
Since we are several people everyone have different starting weight but I need a formula that transforms, in this case, the first weigh-in (92) to 100%.
In the example above the next week this imaginary person weigh-in at 89. Now I need to put in a formula in the first field marked with ? (B3) and then keep on doing so in every field marked ?.
I want every field marked with ? to show the % weight loss from 100%, meaning it will always use the 100% start field, not the previous week.

I hope I make any sense to you helpers out there. If not, please tell me what you don't understand and I will try to explain it better.
Hope anyone can help me with this!

Thanks!
Kim Cefa
Sweden

[shg]

Welcome to the forum.

Row\Col	A	B	C
1	weight (kilo)	Change
2	92	0.0%	B2: =A2/A$2 - 1
3	89	-3.3%
4	88	-4.3%
5	85	-7.6%
6	81	-12.0%

[cefa]

Thank you so very much for that fast answer!
Got it all working now

[abousetta]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.