Meaning of "--" in formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JoAnn - 25 Mar 2008 17:49 GMT

I sometimes see formulas with -- before a set of parenthesis (sample formula
below), can anyone tell me what the purpose of it is? I can't seem to find
it documented anywhere.

For example:
=SUMPRODUCT(--(MONTH(b7:b400)=MONTH(D417)), --(YEAR(b7:b400)=YEAR(D417))

Thanks

Signature

JoAnn

Reply to this Message

Cimjet - 25 Mar 2008 17:59 GMT

Hi JoAnn

The -- stuff changes trues and falses
to 1's and 0's. Logic expression to numeric expression.
Regards
Cimjet

>I sometimes see formulas with -- before a set of parenthesis (sample
>formula
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

JoAnn - 25 Mar 2008 18:17 GMT

Great! Thanks.

Signature

JoAnn

> Hi JoAnn
>
[quoted text clipped - 13 lines]
> >
> > Thanks

Reply to this Message

Michael M - 25 Mar 2008 23:31 GMT

Hi JoAnn
Further to Cimjets answer.
The -- is called a Double Unary and the simple way to see Cimjets answer is
to take them out of the formula and see the result in the formula bar.
It will refer to True or false rather than a mathematical result

Regards
Michael M

> Great! Thanks.
>
[quoted text clipped - 15 lines]
> > >
> > > Thanks

Reply to this Message

Rate this thread: