Bad Cell ?
 

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

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.


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

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