I am trying to create a weigh-in tracker. I want to enter in a starting weight and for each weigh in day enter in the new weight. Below each weigh in will be a cell to track how much weight was lost that particular day. The problem is that the next day's loss cell shows the previous days weight. It does not change until you enter in that days weight. ( example: A1=weight, A2=how much weight was lost, A3=next days weight, A4=how much weight was lost, A5=next days weight, A6=how much weight was lost). The formula I'm using is "A4=SUM(A1-A3)". The problem is when I do that, A6 will also show A4's value until a new weight is entered into A5. How can I make the cells below show a zero value?
Sorry for the noob question...
Bookmarks