Double hyphens --
 

What does a double hyphen do in a formual?
e.g. =SUMPRODUCT(--(Sheet2!$A$2:$A$100=$A2),--(Sheet2!$H$2:$H$100="H98"))

I saw that as a response in a different post, and I've seen the "--" in
other responses but have not been successful in finding it in help

Double hyphens --
 

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

SteveM wrote:

What does a double hyphen do in a formual?
e.g. =SUMPRODUCT(--(Sheet2!$A$2:$A$100=$A2),--(Sheet2!$H$2:$H$100="H98"))

I saw that as a response in a different post, and I've seen the "--" in
other responses but have not been successful in finding it in help

--

Dave Peterson

Double hyphens --
 

It's double unary. It, in this case, forces a TRUE or FALSE argument into a
numerical value of 1 or 0. If you do a search for double unary, you might
find some better explanations, but essentially, it takes a text argument and
converts it (if able) into a numeric argument.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"SteveM" wrote:

What does a double hyphen do in a formual?
e.g. =SUMPRODUCT(--(Sheet2!$A$2:$A$100=$A2),--(Sheet2!$H$2:$H$100="H98"))

I saw that as a response in a different post, and I've seen the "--" in
other responses but have not been successful in finding it in help

Double hyphens --
 

Please, John, it is double unary NEGATION. The operators - and + can both be
used in a unary form (ie operating on only one argument) So we can have =+A1
and =-A1 (just because the first one does nothing does not alter the logic)
Sorry to be nit-picking!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John C" <johnc@stateofdenial wrote in message
...
It's double unary. It, in this case, forces a TRUE or FALSE argument into
a
numerical value of 1 or 0. If you do a search for double unary, you might
find some better explanations, but essentially, it takes a text argument
and
converts it (if able) into a numeric argument.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"SteveM" wrote:

What does a double hyphen do in a formual?
e.g. =SUMPRODUCT(--(Sheet2!$A$2:$A$100=$A2),--(Sheet2!$H$2:$H$100="H98"))

I saw that as a response in a different post, and I've seen the "--" in
other responses but have not been successful in finding it in help

Double hyphens --
 

Okay, so, apprently you completely disregardded my statement of
.... If you do a search for double unary, you might find some better
explanations ...
??? Sorry to be nitpicky, but I qualified my response already.
--
** John C **

"Bernard Liengme" wrote:

Please, John, it is double unary NEGATION. The operators - and + can both be
used in a unary form (ie operating on only one argument) So we can have =+A1
and =-A1 (just because the first one does nothing does not alter the logic)
Sorry to be nit-picking!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John C" <johnc@stateofdenial wrote in message
...
It's double unary. It, in this case, forces a TRUE or FALSE argument into
a
numerical value of 1 or 0. If you do a search for double unary, you might
find some better explanations, but essentially, it takes a text argument
and
converts it (if able) into a numeric argument.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"SteveM" wrote:

What does a double hyphen do in a formual?
e.g. =SUMPRODUCT(--(Sheet2!$A$2:$A$100=$A2),--(Sheet2!$H$2:$H$100="H98"))

I saw that as a response in a different post, and I've seen the "--" in
other responses but have not been successful in finding it in help

Double hyphens --
 

PEACE
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John C" <johnc@stateofdenial wrote in message
...
Okay, so, apprently you completely disregardded my statement of
... If you do a search for double unary, you might find some better
explanations ...
??? Sorry to be nitpicky, but I qualified my response already.
--
** John C **

"Bernard Liengme" wrote:

Please, John, it is double unary NEGATION. The operators - and + can both
be
used in a unary form (ie operating on only one argument) So we can have
=+A1
and =-A1 (just because the first one does nothing does not alter the
logic)
Sorry to be nit-picking!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John C" <johnc@stateofdenial wrote in message
...
It's double unary. It, in this case, forces a TRUE or FALSE argument
into
a
numerical value of 1 or 0. If you do a search for double unary, you
might
find some better explanations, but essentially, it takes a text
argument
and
converts it (if able) into a numeric argument.
--
** John C **
Please remember if your question is answered, to mark it answered :).
It
helps everyone.


"SteveM" wrote:

What does a double hyphen do in a formual?
e.g.
=SUMPRODUCT(--(Sheet2!$A$2:$A$100=$A2),--(Sheet2!$H$2:$H$100="H98"))

I saw that as a response in a different post, and I've seen the "--"
in
other responses but have not been successful in finding it in help

Double hyphens --
 

*sigh*, now I am sad, you missed my joke. The fact is, if I have to exlpain
it, it's isn't that funny. Was wondering if you'd catch my typos in my
response to you.
--
** John C **

"Bernard Liengme" wrote:

PEACE
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John C" <johnc@stateofdenial wrote in message
...
Okay, so, apprently you completely disregardded my statement of
... If you do a search for double unary, you might find some better
explanations ...
??? Sorry to be nitpicky, but I qualified my response already.
--
** John C **

"Bernard Liengme" wrote:

Please, John, it is double unary NEGATION. The operators - and + can both
be
used in a unary form (ie operating on only one argument) So we can have
=+A1
and =-A1 (just because the first one does nothing does not alter the
logic)
Sorry to be nit-picking!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John C" <johnc@stateofdenial wrote in message
...
It's double unary. It, in this case, forces a TRUE or FALSE argument
into
a
numerical value of 1 or 0. If you do a search for double unary, you
might
find some better explanations, but essentially, it takes a text
argument
and
converts it (if able) into a numeric argument.
--
** John C **
Please remember if your question is answered, to mark it answered :).
It
helps everyone.


"SteveM" wrote:

What does a double hyphen do in a formual?
e.g.
=SUMPRODUCT(--(Sheet2!$A$2:$A$100=$A2),--(Sheet2!$H$2:$H$100="H98"))

I saw that as a response in a different post, and I've seen the "--"
in
other responses but have not been successful in finding it in help