Hi Lawson,

Your observed result is consistent with B10 containing a formula which
returns "". It is not consistent with B10 being empty.

To deal with the first scenario, try:

If IsNumeric(Range("B10").Value) And Range("B10") 0 _
Then Range("H31") = 1

---
Regards,
Norman



"Lawson" wrote in message
...
how come blank cells have a value of greater than 0???

i have a simple formula:

If Range("b10") 0 Then Range("h31") = 1

b10 is blank, yet is still sets h31 = 1

how do i get around this???