too FAT and need a couple of formulas for my wieght loss...!

[berbes]

howdy.

at 40 and growing daily, going on a regiment for weight loss. i have a column headings 'weight', 'weekly weight loss (%)', and 'total weight loss (%)', and rows runnig downward for weeks 1-12. i know these are simple formulas, but it's monday...can someone help?

thanks as always, gentlemen!

 

[Lewiy]

Something like this perhaps:

Excel Workbook
	A	B	C	D
1	Week	Weight	Weekly%	Total%
2	1	200
3	2	190	5.00%	5.00%
4	3	185	2.63%	7.50%
5	4	176	4.86%	12.00%
6	5	170	3.41%	15.00%
7	6	150	11.76%	25.00%
Sheet2

 

[Richard Schollar]

Do you mean this sort of thing:

Excel Workbook
	A	B	C	D
1	Week	Weight	WeightLossWeek%	WeightLossTotal%
2	1	250	0	0
3	2	245	2.00%	2.00%
4	3	241	1.63%	3.60%
5	4	230	4.56%	8.00%
6	5	233	-1.30%	6.80%
7	6	231	0.86%	7.60%
8	7	228	1.30%	8.80%
9	8	225	1.32%	10.00%
10	9	225	0.00%	10.00%
11	10	224	0.44%	10.40%
Sheet3

formula in C3 and D3 copied down as far as required.

 

[Richard Schollar]

Lewiy - 200lb is NOT overweight. Man I'd be obese if that was the case Shame on you!!!

 

[Lewiy]

Who said I was measuring it in Lbs? I’m a metric kinda guy!!

 

[Richard Schollar]

Who said I was measuring it in Lbs? I’m a metric kinda guy!!