View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scossa Scossa is offline
external usenet poster
 
Posts: 26
Default Binary operator (?)

On 18 Mar, 13:31, Dave Peterson wrote:
You got the explanation, but this is one reason I like this format:
=countif(a1:a30,""&"")

or even
=countif(a1:a30,""&999)

I think it makes it easier to see what's happening.

On 03/18/2011 02:37, Scossa wrote:





Hello,


I' apologize for my bad english......


Everyone know logical operator "=", "","<","=", "<=", but 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.


I haven't found nothing in on-line Excel documentation *about this.


Ideas???


Bye!
Scossa


--
Dave Peterson- Nascondi testo citato

- Mostra testo citato -


Ok, tnks.