Use of "--"

[Sandeep Jangra]

D'all,
what is the meaning of "--" in a formula.

 

[Mike H]

Hi,

The double minus -- or more correctly the double unary coerces logical
values to numeric values of 1 (true) or 0 (False)


formula like SUMPRODUCT can then add these up to obtain the result.

Mike

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html