I took a spreadsheet that originally came from a Works wizard (I think that's were it came from, I did it some time ago) and pasted it in to Excel.
It includes many equations similar to this one:
It seems to me that the purpose of this cell is to prevent #VALUE! from appearing in the cell until all data is entered in to H4, H5 and H6. But the #VALUE! (or DIV/0) still shows up in all the cells until all the payment data is entered
Why aren't the cells showing up as blanks until all the data has been input?