To Fran Kabel

Sorry. I lost track of the thread in which I asked the
question about dashes in a SUMPRODUCT function.

You responded the dashes forced Boolean values to
numbers, and I then asked if there is documentation
anywhere in Excel, so that I can study it more. I've been
searching for the thread, so I could read your answer,
but I can't find it. Would you mind answering Here?

Thanks

Hi
there is no documentation in the Excel help file for this (as this is
not the standard usage of SUMPRODUCT).
I hope Ken reads this thread as he has an excellent explanantion for
SUMPRODUCT (and I do not find it at the moment)

--
Regards
Frank Kabel
Frankfurt, Germany

LEB wrote:
Sorry. I lost track of the thread in which I asked the
question about dashes in a SUMPRODUCT function.

You responded the dashes forced Boolean values to
numbers, and I then asked if there is documentation
anywhere in Excel, so that I can study it more. I've been
searching for the thread, so I could read your answer,
but I can't find it. Would you mind answering Here?

Thanks

Sorry I left the "K" off your first name in the first
post.

-----Original Message-----
Sorry. I lost track of the thread in which I asked the
question about dashes in a SUMPRODUCT function.

You responded the dashes forced Boolean values to
numbers, and I then asked if there is documentation
anywhere in Excel, so that I can study it more. I've
been
searching for the thread, so I could read your answer,
but I can't find it. Would you mind answering Here?

Thanks
.

I'm not Frank, but it's no mystery:

The - is a "minus" operator (see "Calculation operators in formulas" in
XL Help).

All math operators attempt to coerce text or boolean values to numbers,
if possible. Boolean values (TRUE/FALSE) are coerced to 1/0,
respectively, so - coerces

-(TRUE)

to -1 and

-(FALSE)

to 0. The second unary minus operator converts -1 to +1 to come out with
a positive number.


In article ,
"LEB" wrote:

Sorry. I lost track of the thread in which I asked the
question about dashes in a SUMPRODUCT function.

You responded the dashes forced Boolean values to
numbers, and I then asked if there is documentation
anywhere in Excel, so that I can study it more. I've been
searching for the thread, so I could read your answer,
but I can't find it. Would you mind answering Here?

Thanks

Look up this answer to a previous question which covers this ground

http://tinyurl.com/ywdw4


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"LEB" wrote in message
...
Sorry. I lost track of the thread in which I asked the
question about dashes in a SUMPRODUCT function.

You responded the dashes forced Boolean values to
numbers, and I then asked if there is documentation
anywhere in Excel, so that I can study it more. I've been
searching for the thread, so I could read your answer,
but I can't find it. Would you mind answering Here?

Thanks

JE,

Any reason that -- is used instead of just +?

Thanks,
Bernie
MS Excel MVP

"JE McGimpsey" wrote in message
...
I'm not Frank, but it's no mystery:

The - is a "minus" operator (see "Calculation operators in formulas" in
XL Help).

All math operators attempt to coerce text or boolean values to numbers,
if possible. Boolean values (TRUE/FALSE) are coerced to 1/0,
respectively, so - coerces

-(TRUE)

to -1 and

-(FALSE)

to 0. The second unary minus operator converts -1 to +1 to come out with
a positive number.


In article ,
"LEB" wrote:

Sorry. I lost track of the thread in which I asked the
question about dashes in a SUMPRODUCT function.

You responded the dashes forced Boolean values to
numbers, and I then asked if there is documentation
anywhere in Excel, so that I can study it more. I've been
searching for the thread, so I could read your answer,
but I can't find it. Would you mind answering Here?

Thanks

Hi Bernie
maybe as the formula
=+TRUE
still return TRUE
but
=--TRUE
does return 1

--
Regards
Frank Kabel
Frankfurt, Germany

Bernie Deitrick wrote:
JE,

Any reason that -- is used instead of just +?

Thanks,
Bernie
MS Excel MVP

"JE McGimpsey" wrote in message
...
I'm not Frank, but it's no mystery:

The - is a "minus" operator (see "Calculation operators in formulas"
in XL Help).

All math operators attempt to coerce text or boolean values to
numbers, if possible. Boolean values (TRUE/FALSE) are coerced to
1/0,
respectively, so - coerces

-(TRUE)

to -1 and

-(FALSE)

to 0. The second unary minus operator converts -1 to +1 to come out
with a positive number.


In article ,
"LEB" wrote:

Sorry. I lost track of the thread in which I asked the
question about dashes in a SUMPRODUCT function.

You responded the dashes forced Boolean values to
numbers, and I then asked if there is documentation
anywhere in Excel, so that I can study it more. I've been
searching for the thread, so I could read your answer,
but I can't find it. Would you mind answering Here?

Thanks

Thanks. So JE's statement

All math operators attempt to coerce text or boolean values to numbers, if
possible.

is slightly too generalized.

Bernie
MS Excel MVP

"Frank Kabel" wrote in message
...
Hi Bernie
maybe as the formula
=+TRUE
still return TRUE
but
=--TRUE
does return 1

--
Regards
Frank Kabel
Frankfurt, Germany

Bernie Deitrick wrote:
JE,

Any reason that -- is used instead of just +?

Thanks,
Bernie
MS Excel MVP

"JE McGimpsey" wrote in message
...
I'm not Frank, but it's no mystery:

The - is a "minus" operator (see "Calculation operators in formulas"
in XL Help).

All math operators attempt to coerce text or boolean values to
numbers, if possible. Boolean values (TRUE/FALSE) are coerced to
1/0,
respectively, so - coerces

-(TRUE)

to -1 and

-(FALSE)

to 0. The second unary minus operator converts -1 to +1 to come out
with a positive number.


In article ,
"LEB" wrote:

Sorry. I lost track of the thread in which I asked the
question about dashes in a SUMPRODUCT function.

You responded the dashes forced Boolean values to
numbers, and I then asked if there is documentation
anywhere in Excel, so that I can study it more. I've been
searching for the thread, so I could read your answer,
but I can't find it. Would you mind answering Here?

Thanks

Thanks for all the help. It makes sense now.
-----Original Message-----
Sorry. I lost track of the thread in which I asked the
question about dashes in a SUMPRODUCT function.

You responded the dashes forced Boolean values to
numbers, and I then asked if there is documentation
anywhere in Excel, so that I can study it more. I've
been
searching for the thread, so I could read your answer,
but I can't find it. Would you mind answering Here?

Thanks
.

Hi JE
one could argue if '+ some_value' is a mathematical operation as this
does not change the value at all :-)

--
Regards
Frank Kabel
Frankfurt, Germany

Bernie Deitrick wrote:
Thanks. So JE's statement

All math operators attempt to coerce text or boolean values to
numbers, if possible.

is slightly too generalized.

Bernie
MS Excel MVP

"Frank Kabel" wrote in message
...
Hi Bernie
maybe as the formula
=+TRUE
still return TRUE
but
=--TRUE
does return 1

--
Regards
Frank Kabel
Frankfurt, Germany

Bernie Deitrick wrote:
JE,

Any reason that -- is used instead of just +?

Thanks,
Bernie
MS Excel MVP

"JE McGimpsey" wrote in message
...
I'm not Frank, but it's no mystery:

The - is a "minus" operator (see "Calculation operators in
formulas" in XL Help).

All math operators attempt to coerce text or boolean values to
numbers, if possible. Boolean values (TRUE/FALSE) are coerced to
1/0,
respectively, so - coerces

-(TRUE)

to -1 and

-(FALSE)

to 0. The second unary minus operator converts -1 to +1 to come
out
with a positive number.


In article ,
"LEB" wrote:

Sorry. I lost track of the thread in which I asked the
question about dashes in a SUMPRODUCT function.

You responded the dashes forced Boolean values to
numbers, and I then asked if there is documentation
anywhere in Excel, so that I can study it more. I've been
searching for the thread, so I could read your answer,
but I can't find it. Would you mind answering Here?

Thanks