Hi Cyberspace,
I'd like to understand the meaning of "--" in front of an Excel
function like :
=--sumproduct(...)
=--substitute(...)
... and other I can't recall
I know that in some programming language it's a way to "decrement" a
variable like i = i - 1 can be i-- or --i following the precedence
Dear johann,
The -- is used as an unary operator to convert a boolean value ie,
TRUE/FALSE in to 1/0. Sumproduct for example does not evaluate non-numeric
values that results in a formula like the boolean results in the array
equation A1:A10="johann".
So to negate this, we use unary operator -- w
come a criteria for what to
summarize.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Wednesday, February 22, 2012 7:06 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Meaning of minus minus or -- in an
ize.
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* Wednesday, February 22, 2012 7:06 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-M
is True/1, or not, when
>> False/0. That boolean value or expression has become a criteria for what
>> to summarize.
>>
>> ** **
>>
>> Asa
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@goo
be included in a summary when the boolean is True/1, or not, when
> False/0. That boolean value or expression has become a criteria for what
> to summarize.
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegro
Thanks, Chandru.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Thursday, February 23, 2012 9:15 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel
function
Dear
gt;"France")*NOT(ISBLANK(Customer[Sales])),Customer[Sales]))
>
>
> ** **
>
> The attached files demonstrate. The xlsx version has both 2010 table
> reference and traditional range reference versions of the formulas; the xls
> version just has range versions.
>
> ** **
>
>
what about :
{=LARGE(- -($E$1:$E$122=$G1)*$F$1:$F$122,COUNTIF($G$1:$G1,$G1))}
?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of johann
Sent: Friday, February 24, 2012 12:49 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel
function
what about :
{=LARGE(- -($E$1:$E$1
moment though :)
>
> Asa
>
>
>
>
>
>
>
> -----Original Message-----
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of johann
> Sent: Friday, February 24, 2012 12:49 PM
> To: MS EXCEL AND VBA MACROS
> Sub
mula is at the moment though :)
>
>
>
> Asa
>
>
>
> -----Original Message-----
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of johann
> Sent: Friday, February 24, 2012 12:49 PM
> To: MS EXCEL AND VBA MACROS
> Sub
ll
> function of your formula is at the moment though :)
>
>
>
> Asa
>
>
>
> -----Original Message-----
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of johann
> Sent: Friday, February 24, 2012 12:49 PM
> To: MS EXCEL AN
13 matches
Mail list logo