Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |