But it is hard to understand the rational behind "TEXT is considered as
0";
I know those are the rules but it does not make much sense...

The software programmers did that!

More specifically, TEXT evaluates to any number.

Biff

"Nicoscot" wrote in message
...
Thanks Biff
But it is hard to understand the rational behind "TEXT is considered as
0";
I know those are the rules but it does not make much sense...

"Biff" wrote:

Stop pulling your hair out!

Example: The cell A1 is empty

If A1 contains a formula that returns a formula blank: "", that cell IS
NOT
EMPTY.

If A1 truly was EMPTY then: =A1 would return 0.

=if(isblank(A2);"empty";"full")

The ISBLANK function does not recognize formula blanks as blank cells so
that's why you get "full".

=IF(A2="","empty","full") will return "empty".

=if(A20;"number higher than 0";"other")

If A2 contains the formula =A1 and A1 contains a formula blank, then A2 =
""
which is a TEXT value. A TEXT value will ALWAYS evaluate to 0 so that's
why
you get "number higher than 0".

Biff

"Nicoscot" wrote in message
...
I do not understand why a cell that contains a formula which result is
empty
is not considered as an empty cell.
Example: The cell A1 is empty; in cell A2 I type =A1; in cell A3 I type
=if(isblank(A2);"empty";"full") and the result in A3 is... "full". I do
not
get it.
Other example:The cell A1 is empty; in cell A2 I type =A1; in cell A3 I
type
=if(A20;"number higher than 0";"other") and the result in A3 is...
"number
higher than 0"!!!!.... Even in the case that the value in A2 was 0 how
could
it be strictly superior to 0!!! That makes no sense at all.
Please tell me how to create a reference to an empty cell whose result
is
indeed an empty cell. I am going crazy.