Enter hyphen instead of zero in blank cell
Select File, Options, Advanced and you have a default choice to leave a cell which has a formula but no data to show either a blank cell or a zero. I suggest another choice should be allowed as a default. A hyphen,
That way you would know there is a formula in the cell and not to place data in the cell over writing the formula.