Help Weight Loss

[agoodson56]

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> I am trying to build a weight loss tracker that runs left to right in a row.

In a row I am entering my weight each Monday for 14 weeks.

At the end of the row I want to total what my weight loss is or what my new weight is.

 

[agoodson56]

How do I clear the zeros as they are linked to another page the the infor is input?

 

[T. Valko]

You need to clear your zeros. All our formulae look for the last value, if it's 0, the difference between the start weight and the end weight is the start weight (270.8 - 0 = 270.8).

Keep future weights blank and the formulae should work.

It would be better to remove all the 0s but not a necessity.

=F4-LOOKUP(2,1/(F4:AF>0),F4:AF4)

 

[T. Valko]

How do I clear the zeros as they are linked to another page the the infor is input?

It would be better to remove all the 0s but not a necessity.

=F4-LOOKUP(2,1/(F4:AF>0),F4:AF4)