View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daren Daren is offline
external usenet poster
 
Posts: 162
Default Purpose of Double Unary in AND Statement

Thanks!

"T. Valko" wrote:

It could be because the referenced cells contain TEXT numbers. The "--" will
coerce TEXT numbers to NUMERIC numbers.


--
Biff
Microsoft Excel MVP


"Daren" wrote in message
...
Hello,

The AND statement is as follows:

=and(--d2--c2,--c2--b2m--b2--a2).

What's the purpose of the double unary here?

Thanks!