Hi whatsup,



This actually worked for the 0! Yeah! It still gives me a 1 for a blank cell, but I can get around that. The 0 was my main issue!

Thanks a bunch!! Much appreciated!

Nat

Hi whatsup,

Update...It actually does work on a blank cell, as long as I do not add a number and then delete. This will work just fine overall.

Thanks,
Nat

Now that seems to be a problem the way you delete the contains of a cell. Sticking to F20, if
= LEN(F20)
results in zero, then the formula will work correctly, if you insert for example <space> then it won't. Though the cell appears empty it isn't, and above formula will result in 1.

As explanation, with
OR(F20="",F20=0,F20="0")
you check three cases for F20:
- "" = the cell is empty or (as a result of a formula) contains an empty string
- 0 = the cell contains a 0 as number
- "0" = the cell contains a 0 as text (string)
in either case, the formula will return a fixed result of zero!!!

Thanks I see what you mean.

Nat