Bad Cell ?

[jziggy]

I am using the formula IF(H20<=0,"PD","") in one of my worksheets, and
in a few of the cells it does not recognize the contents $0.00 as being
<or= to 0, and does not put PD in the appropriate cell. Could I have bad
cells in my worksheet?

 

[Coltsfan]

I tested your formula and the only way it won't read PD is if your cell
is formated to TEXT instead of currency or a dollar amount. If it is
formated to text it is reading the $ as something higher than zero.
Hoped that helped.

 

[Ken]

Hi,
It could be that you have some rounding issues. Perhaps the cells contents
are really $0.0000006?
If you try =IF(ROUND(H20,2)<=0,"PD",""), do the results change?