I seem to be having problems with cells and Formulas that depend on the contents of that cell.
When there is a zero in a cell the Formula works.
When there is a Number , and then the number is cleared then sometimes the Formula thinks there is a zero in the cell and sometimes it thinks there is a Null in the cell.
And sometimes if I type a word inthe cell , then the Formula thinks there is a number greater than zero in the cell.

This Formula is preceded by the IF Statement.