What does -- mean?
in [General]
|
From: Ron on 14 Feb 2005 15:11 I have been seeing "--" in formulae but cannot find an explanation of what it is or does. Example: =SUMPRODUCT(--(MONTH(B2:B13)=1), C2:C13) -- Ron P Sometimes you're the windshield:) Sometimes you're the bug:(
From: Bob Phillips on 14 Feb 2005 15:21 See http://www.xldynamic.com/source/xld.SUMPRODUCT.html Multiple Condition Tests for a full explanation. -- HTH RP (remove nothere from the email address if mailing direct) "Ron" <spam(a)kwic.com> wrote in message news:O6wBgFtEFHA.548(a)TK2MSFTNGP14.phx.gbl... > I have been seeing "--" in formulae but cannot find an explanation of what > it is or does. > > Example: =SUMPRODUCT(--(MONTH(B2:B13)=1), C2:C13) > > > -- > > Ron P > > Sometimes you're the windshield:) > Sometimes you're the bug:( > > >
From: Ken Wright on 14 Feb 2005 15:34 As Peo pointed out in another post:- For January you need to add another condition =SUMPRODUCT(--(MONTH(A1:A100)=1),--(ISNUMBER(A1:A100))) it's because that excel sees blank cells as zero and excel dates dtart with January zero 1900 the unary minuses will convert boolean values of true and false to 1 and 0 http://www.mcgimpsey.com/excel/formulae/doubleneg.html -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Ron" <spam(a)kwic.com> wrote in message news:O6wBgFtEFHA.548(a)TK2MSFTNGP14.phx.gbl... > I have been seeing "--" in formulae but cannot find an explanation of what > it is or does. > > Example: =SUMPRODUCT(--(MONTH(B2:B13)=1), C2:C13) > > > -- > > Ron P > > Sometimes you're the windshield:) > Sometimes you're the bug:( > > >
From: Ron on 15 Feb 2005 09:20 "Bob Phillips" <bob.phillips(a)notheretiscali.co.uk> wrote in message news:uqphOLtEFHA.3492(a)TK2MSFTNGP12.phx.gbl... > See > > http://www.xldynamic.com/source/xld.SUMPRODUCT.html > Multiple Condition Tests > > for a full explanation. > > -- > > HTH > > RP > (remove nothere from the email address if mailing direct) > > > "Ron" <spam(a)kwic.com> wrote in message > news:O6wBgFtEFHA.548(a)TK2MSFTNGP14.phx.gbl... >> I have been seeing "--" in formulae but cannot find an explanation of >> what >> it is or does. >> >> Example: =SUMPRODUCT(--(MONTH(B2:B13)=1), C2:C13) Thank you very much. It now makes sense. Ron
From: Ron on 15 Feb 2005 09:21 "Ken Wright" <ken.wright(a)NOSPAMntlworld.com> wrote in message news:OfF2nStEFHA.548(a)TK2MSFTNGP14.phx.gbl... > As Peo pointed out in another post:- > > For January you need to add another condition > > =SUMPRODUCT(--(MONTH(A1:A100)=1),--(ISNUMBER(A1:A100))) > > it's because that excel sees blank cells as zero and excel dates dtart > with > January zero 1900 the unary minuses will convert boolean values of true > and > false to 1 and 0 > > http://www.mcgimpsey.com/excel/formulae/doubleneg.html > > -- > Regards > Ken....................... Microsoft MVP - Excel > Sys Spec - Win XP Pro / XL 97/00/02/03 > > ---------------------------------------------------------------------------- > It's easier to beg forgiveness than ask permission :-) > ---------------------------------------------------------------------------- Thank you very much. I hadn't come across this before. It makes sense. Thanks Ron
|
Pages: 1 Prev: How do I type the Spanish letter N? Next: Aligning decimals in Excel ... |