Solved: what does -- do

[philfer]

Hello,

I have seen this double minus sign in a few pieces of code

What are the implications of this double minus

Thanks
Phil

[Kenneth Hobs]

It is generally used with =SumProduct. See Bob's site for details.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

[david000]

Also, try typing in a couple cells...

=--TRUE
=--FALSE


or referance cells that have just the word, 'TRUE' or 'FALSE' in them. They will be evaluated to '1' and '0' respectively.

so, as you get the hang of it you can build up from there like;

8 = SUM((--{TRUE,TRUE,TRUE,FALSE,TRUE})+(--{TRUE,TRUE,TRUE,FALSE,TRUE}))