Quote:
Originally Posted by BobBridges
I just checked to be sure, and, as you might expect, when I have nothing in X99, then X99>0 evaluates as false. So my next theory is that there's something in there already. I just discovered (thanks to your question) that a space is actually considered to be >0. So I'm thinking H5 has a space in it, or more than one.
|
Quote:
Originally Posted by macropod
Your first formula outputs a number or null into H5. A null is not the same as no data and has a non-zero value. Accordingly, your subsequent formula needs to test for nulls (i.e. "") as well.
|
Both quite right, nulls do appear to have 0 length though so =IF(LEN(H5)>0 works fine.