Check whether it is really zero; or displayed as zero

=IF(J22<0,1000,IF(INT(J22)=0,I23,0))

If this post helps click Yes
---------------
Jacob Skaria


"Sander" wrote:

For I22: =IF(J22<0,1000,IF(J220,0,I23)).

This works when J22 or < 0, but not when J22=0, when it should take I23.

Why is that? Thank you.