Weight Monitoring

[nhadcab]

Hi All,

I've been struggling in how to come up with a decent formula in order to see the trending regarding weight loss/weight gain for our group over a duration of 12 weeks.
I've used the if formula, but still unable to create a decent formula that would address our trending.

we do weekly weigh in and we enter it on columns C,E,G,I,K
for column D,F,H,J,L, we want to see if there is any weight loss or weight gain, but if no weight was entered on the weight column, it will show NWEFW (no weight entered for the week), and as soon as they enter it on a particular week, for example for Name B, it will show NWEFW for wk 1,2,3 and for wk 3 it will compute the weight entered versus the baseline.

Does that make sense? thank you kindly and hoping for your assistance regarding this. I'm really not good at excel other than doing the basic formula. and if there is a way look and create a more basic way of trending please do let me know.

Thanks
[TABLE="width: 823"]
<tbody>[TR]
[TD="class: xl64, width: 150, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Baseline
[/TD]
[TD="class: xl66, width: 128, bgcolor: transparent, colspan: 2"]WK 1
[/TD]
[TD="class: xl66, width: 128, bgcolor: transparent, colspan: 2"]WK 2
[/TD]
[TD="class: xl66, width: 128, bgcolor: transparent, colspan: 2"]WK 3
[/TD]
[TD="class: xl66, width: 128, bgcolor: transparent, colspan: 2"]WK 4
[/TD]
[TD="class: xl66, width: 128, bgcolor: transparent, colspan: 2"]WK 5
[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="class: xl63, width: 114, bgcolor: transparent"]TOTAL PROGRESS
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Coach Name
[/TD]
[TD="class: xl68, bgcolor: transparent"]Weight
[/TD]
[TD="class: xl68, bgcolor: transparent"]Weight
[/TD]
[TD="class: xl68, bgcolor: transparent"]Status
[/TD]
[TD="class: xl68, bgcolor: transparent"]Weight
[/TD]
[TD="class: xl68, bgcolor: transparent"]Status
[/TD]
[TD="class: xl68, bgcolor: transparent"]Weight
[/TD]
[TD="class: xl68, bgcolor: transparent"]Status
[/TD]
[TD="class: xl68, bgcolor: transparent"]Weight
[/TD]
[TD="class: xl68, bgcolor: transparent"]Status
[/TD]
[TD="class: xl68, bgcolor: transparent"]Weight
[/TD]
[TD="class: xl68, bgcolor: transparent"]Status
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Name A
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]137
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]136.9
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]138
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]138
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]133.8
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Name B
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]212
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]212
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]212
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Name C
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]150
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]150.3
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]150.3
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]150.3
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]150.3
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]150.3
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]