Matrix info

[Andreas Håkansson]

Hi,

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

news:OgRD7kQUGHA.1572@tk2msftngp13.phx.gbl

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!

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.

"Andreas Håkansson" <andreas.hakansson@sembo.se> wrote in message
news:uXOhM8YUGHA.1868@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> In a previous post of mine, a person called Biff helped me with another
> problem (Thanks, again Biff!).
>
> news:OgRD7kQUGHA.1572@tk2msftngp13.phx.gbl
>
> 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!
>

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

Cheers.

<Andy> wrote in message news:esx4DCZUGHA.4900@TK2MSFTNGP12.phx.gbl...
> 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.
>
> "Andreas Håkansson" <andreas.hakansson@sembo.se> wrote in message
> news:uXOhM8YUGHA.1868@TK2MSFTNGP09.phx.gbl...
>> Hi,
>>
>> In a previous post of mine, a person called Biff helped me with another
>> problem (Thanks, again Biff!).
>>
>> news:OgRD7kQUGHA.1572@tk2msftngp13.phx.gbl
>>
>> 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!
>>
>
>

[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)

"Andreas Håkansson" <andreas.hakansson@sembo.se> wrote in message
news:uXOhM8YUGHA.1868@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> In a previous post of mine, a person called Biff helped me with another
> problem (Thanks, again Biff!).
>
> news:OgRD7kQUGHA.1572@tk2msftngp13.phx.gbl
>
> 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!
>
>

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" <bob.phillips@notheretiscali.co.uk> wrote in message
news:OQqxzHZUGHA.1564@TK2MSFTNGP11.phx.gbl...
> 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" <andreas.hakansson@sembo.se> wrote in message
> news:uXOhM8YUGHA.1868@TK2MSFTNGP09.phx.gbl...
>> Hi,
>>
>> In a previous post of mine, a person called Biff helped me with another
>> problem (Thanks, again Biff!).
>>
>> news:OgRD7kQUGHA.1572@tk2msftngp13.phx.gbl
>>
>> 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!
>>
>>
>
>

[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)

<Andy> wrote in message news:u%23zpjOZUGHA.5828@TK2MSFTNGP10.phx.gbl...
> 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" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:OQqxzHZUGHA.1564@TK2MSFTNGP11.phx.gbl...
> > 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" <andreas.hakansson@sembo.se> wrote in message
> > news:uXOhM8YUGHA.1868@TK2MSFTNGP09.phx.gbl...
> >> Hi,
> >>
> >> In a previous post of mine, a person called Biff helped me with another
> >> problem (Thanks, again Biff!).
> >>
> >> news:OgRD7kQUGHA.1572@tk2msftngp13.phx.gbl
> >>
> >> 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!
> >>
> >>
> >
> >
>
>