weight tracker help

[JMITCH26]

When I enter in my weight it gives me a big negative number on the line below. I'm sure there is a way to fix this to report nothing on the line below my last entry. I'm just not sure how to do it.
(Data)
Weight Loss +/- Daily
Cell D E F
1 173.8 -39.7 -0.8
2 172.0 -41.5 -1.8
3 -172.0

Line 3 Cell F is reporting a big loss in the daily before I enter anything for that day. Then when I add the data to line 3 Cell D the big loss number will be on line 4 Cell F.


(Formula)
Cell D E F
1 173.8 =IF(D91="","",D91-$C$4) =D91-D90
2 172.0 =IF(D92="","",D92-$C$4) =D92-D91
3 =IF(D93="","",D93-$C$4) =D93-D94

I like the way it is working now it’s ready for me to make a daily entry but I don’t want to report a daily loss of some big number on the line below.

Any help on this would be great.

Using
Excel 2010

 

[Andrew Poulsom]

It's not clear from your post which column holds the -172.0 but I would guess you need to change the formula in column F to test for null as you have done with the formulas in column E.

 

[WinteE]

Try this :

=IF(E94+F94,D93-F94,0)

 

[Peter_SSs]

I believe Andrew is correct. In column E the first part of your formula checks to see if something is in column D. If not, the column E formula returns a null string "". You just need exactly the same thing in column F. So, the formula in F91 would be:

=IF(D91="","",D91-D90)

Copy this down, & up if necessary.

 

[JMITCH26]

yes that was the answer it works perfect now

Thank you

 

[JMITCH26]

Not sure why the question did not align write when I submited it sorry about that

Peter SS answer was correct

Thanks again

 

[Peter_SSs]

Not sure why the question did not align write when I submited it sorry about that

Just using spaces does not work to align things in the forum. Multiple consecutive spaces get reduced to one when you submit your post. You can pad with dots .... or underscores ___, but the best thing is to post a small actual screen shot. My signature block has several suggestions for that.