I'm trying to put together a complex weight chart to record a few different
items for my wife and I, been so long i cant remember the correct formula to
calculate plus and minus weights in the same column as below.

B2 B3 B4 B5
B6 B7
Start week2 Difference week3
Difference
Weight 150 149 -1 151
2
Bmi 25.2 25.4 .2
24.9 -.5

I want to be able to calculate the differences each week to look like
above, cell B5 should be able to reflect a weight gain or a weight loss,
week3 in cell B7 should do the same, I will format the cell to show 2 decimal
places in each calculated week and the weight difference gain / loss cells,
help please, thanks, Ray

If you insert a blank row in row 3, you can use

=C4-C2 in 5 and copy that to C7 etc.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ray" wrote in message
...
I'm trying to put together a complex weight chart to record a few
different
items for my wife and I, been so long i cant remember the correct formula
to
calculate plus and minus weights in the same column as below.

B2 B3 B4 B5
B6 B7
Start week2 Difference week3
Difference
Weight 150 149 -1
151
2
Bmi 25.2 25.4 .2
24.9 -.5

I want to be able to calculate the differences each week to look like
above, cell B5 should be able to reflect a weight gain or a weight loss,
week3 in cell B7 should do the same, I will format the cell to show 2
decimal
places in each calculated week and the weight difference gain / loss
cells,
help please, thanks, Ray

Thanks Bob, yeah i worked it out, how simple, Duh of me, =D2-C2 for the first
starting point then =F2-D2, copy, paste every second column, so easy, told
you it had been a while, Thanks, Ray

"Bob Phillips" wrote:

If you insert a blank row in row 3, you can use

=C4-C2 in 5 and copy that to C7 etc.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ray" wrote in message
...
I'm trying to put together a complex weight chart to record a few
different
items for my wife and I, been so long i cant remember the correct formula
to
calculate plus and minus weights in the same column as below.

B2 B3 B4 B5
B6 B7
Start week2 Difference week3
Difference
Weight 150 149 -1
151
2
Bmi 25.2 25.4 .2
24.9 -.5

I want to be able to calculate the differences each week to look like
above, cell B5 should be able to reflect a weight gain or a weight loss,
week3 in cell B7 should do the same, I will format the cell to show 2
decimal
places in each calculated week and the weight difference gain / loss
cells,
help please, thanks, Ray