Strange Boolean If function result

[alfredkri]

Hola,
A stepped over a very strange situation (for me) while using the "" value in order to leave a cell empty if the condition is True.
Assume A1 has 123 and B1 has: =IF(A1<100 then "smaller","").
The above formula returns an empty cell.
So far so good.
When I type, in C1: =IF(B1>321,"X","") it returns, to my surprise, X.
My logic, which is probably different from the Excels, says C1 should remain empty - because "" equals zero.
I tried to check: =CODE(B1) which returns: #VALUE!
>Doesn't "" has an ASCII Code?
>Doesn't it Equal zero?
>Does it equal to NULL? and if so can I check something against NULL?
Where am I wrong ?
Thanks, Al

[zbor]

It consider text greater than number so you get that "" is greater than 123

[JBeaucaire]

Believe it or not, text strings (including the NULL text string "") are all greater than any number.

Your C1 formula should test the value of A1 I'd suggest.

[DonkeyOte]

Alternatively, using the example (and ignoring the fact your first formula B1 implies all results shall be text), you can test the numeric value of B1 either via N(B1) or SUM(B1)

Please Login or Register  to view this content.

[alfredkri]

Thanks to you all.
Al