Hi,
I'm trying to make a weight loss spreadsheet (it is January after all!), where you enter your weight in the cells on a weekly basis. Depending on weight compared to target, using an IF formula, you get a message (well done etc).
However, due to the SUM formula in the 'Actual Loss' column, the next week thinks you have lost ALL your weight - as there is nothing in the cell.
So, is there a way to keep the formula, but get the cell to ignore a blank (the message shows well done for the rest of the comment boxes).
(I'm possibly struggling to explain properly, i've attached a copy of sheet to let you se what I mean).
Ideally I want the remaining (future) weeks to be blank and the SUM & IF formula cells to remain blank until a weight is entered...
Thanks.
Bookmarks