Matrix info
 

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:A81)

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

Thanks!

Matrix info
 

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 he
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
but your best bet is to search Google Groups for "unary minus" AND excel

Andy.

"Andreas Håkansson" wrote in message
...
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:A81)

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

Thanks!

Matrix info
 

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

Cheers.

<Andy wrote in message ...
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 he
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
but your best bet is to search Google Groups for "unary minus" AND
excel

Andy.

"Andreas Håkansson" wrote in message
...
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:A81)

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

Thanks!

Matrix info
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Andreas Håkansson" wrote in message
...
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:A81)

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

Thanks!

Matrix info
 

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" wrote in message
...
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Andreas Håkansson" wrote in message
...
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:A81)

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

Thanks!

Matrix info
 

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)

<Andy wrote in message ...
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" wrote in message
...
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Andreas Håkansson" wrote in message
...
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:A81)

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

Thanks!