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?

"jziggy" wrote:


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?


--
jziggy
------------------------------------------------------------------------
jziggy's Profile: http://www.excelforum.com/member.php...o&userid=20019
View this thread: http://www.excelforum.com/showthread...hreadid=346033