Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |