Matrix info

[Andreas Håkansson]

Hi,

In a previous post of mine, a person called Biff helped me with another
problem (Thanks, again Biff!).


his solution used matrixes and I was courious what the double negativesigns
infront of the range was?

--(A1:A8>1)

etc ? Does anyone have a link to a website that explains how to work with
this kind of stuff in excel?

Thanks!

 

[Guest]

Hi

This function (similar to *0) is designed to force Excel into making the
result a number, rather than a TRUE or a FALSE.
It is called unary minus. There is some info here:
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
but your best bet is to search Google Groups for "unary minus" AND excel

Andy.

 

[Guest]

I meant (similar to +0), not *0 !!!

Cheers.

Hi

This function (similar to *0) is designed to force Excel into making the
result a number, rather than a TRUE or a FALSE.
It is called unary minus. There is some info here:
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
but your best bet is to search Google Groups for "unary minus" AND
excel

Andy.

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Aladin Akyurek]

http://www.mrexcel.com/wwwboard/messages/8961.html
http://www.mrexcel.com/board2/viewtopic.php?t=133602

The double negatives or any other coercers like +0, as they are called,
are needed to convert truth-valued arrays/ranges into numerical arrays
(often seen in formulas set up with the SumProduct function) as Excel or
any other spreadsheet software requires in order to calculate. Note that
the coercers are also deployed to convert text-formatted numbers into
true numbers.

Note that A1:A8>1, when evaluated, would yield a bunch of TRUE's and/or
FALSE's. The -- coercer causes Excel to convert these values into their
numerical equivalents (1's and 0's, respectively).

 

[Guest]

Thanks Bob! I've been trying to find that page for weeks! My brother (who
lives in Lymington, by the way) needs some guidance and I knew this page
existed somewhere!

Andy.

 

[Bob Phillips]

Send him on over to me, I am only 20 miles away from him <G>

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[poddys]

Off topic I know, but I used to work in Lymington (Wellworthy - now
gone I think).
I used to live in Poole - now South Florida.