Formula equaling zero is not equal to 0

[smninos]

I have a simple formula which subtracts one cell from another. I then have an if and statement which checks if that cell is equal to zero. If so, continue processing. The problem is that the formula always reads the cell as not equal to zero although the result of the formula contained in the cell does result in zero.

[zbor]

Actually H2<>0 checks is cell NOT equat to zero.

Since it's 0 you'll always get empty cell, no matter on other issue

[smninos]

Maybe I worded my question incorrectly...

=IF(AND(TODAY()>D2,H2<>0),"Past Due","")

If D2 is greater than today AND H2 is not = to 0, then enter "Past Due" into the cell.

The problem is that H2 contains a formula and always appears to contain a value greater than 0 although the result of the formula in H2 is 0.

[ChemistB]

You have your logic backwards, I think. h2<>0 will give a false value when you have 0 in H2, thus triggering your second argument. Is that what you want? If so, I tried a couple of scenarios (H2 neg, positive and 0) and they all worked as per the logic.

[darkyam]

When I open the workbook, H2 is 0 because E2=G2. If you change G2 to any other number, your formula works fine. If you want it to return "Past Due" if H2 is blank, simply change <>0 to <>"".

[smninos]

Thanks darkyam.... sometimes the obvious isn't so