Binary operator (?)
On Mar 18, 12:37*am, Scossa wrote:
i found that this operator "" in a function like CountIf()
=CountIf( A1:A30, "")
returns the numbures of cells that contain text.
But unlike others operators, if you try somthing like
*=A1A3 yuo can't close edit.
You are misinterpreting the COUNTIF parameter, understandably.
The first "" is the comparison operator. The second "" is the
character "".
So COUNTIF(A1:A30,"") counts all cells will text whose strings
compare greater than "".
You can replace the second "" with other characters (e.g. ":") and
get the same result.
You can see things as COUNTIF does by putting =A1"" into B1 and copy
down through B30.
What I do find odd is that ="2""" returns TRUE. The ASCII code for
"2" is 50, and the ASCII code for "" is 62.
|