Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is "--" in Excel Formula (SUMPRODUCT)
I am trying to understand a formula and cannot find Excel documetnation on what the "--" (operator ?) means in Excel 2010. Can someone give me a brief explanation and point me to some documentation where I can at least understand what this is called? I used to think I knew excel pretty well!
Here is a sample formula where it is used along with a number of named ranges/arrays: SUMPRODUCT(--(Planner_Type="I"),--(Planner_Category=Dashboard!$R20),INDIRECT($D$22)) *Filter_Currency_ExchangeRate |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is "--" in Excel Formula (SUMPRODUCT)
On Thursday, November 15, 2012 3:16:48 PM UTC-5, IHN Warrior wrote:
I am trying to understand a formula and cannot find Excel documetnation on what the "--" (operator ?) means in Excel 2010. Can someone give me a brief explanation and point me to some documentation where I can at least understand what this is called? I used to think I knew excel pretty well! Here is a sample formula where it is used along with a number of named ranges/arrays: SUMPRODUCT(--(Planner_Type="I"),--(Planner_Category=Dashboard!$R20),INDIRECT($D$22)) *Filter_Currency_ExchangeRate Hi It's called double unary, it changes "True/False" into 1 and 0's that Sumproduct can use fot its calculation |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is "--" in Excel Formula (SUMPRODUCT)
Excellent. Thanks for the lesson. I understand now!
On Thursday, November 15, 2012 12:57:19 PM UTC-8, Cimjet wrote: On Thursday, November 15, 2012 3:16:48 PM UTC-5, IHN Warrior wrote: I am trying to understand a formula and cannot find Excel documetnation on what the "--" (operator ?) means in Excel 2010. Can someone give me a brief explanation and point me to some documentation where I can at least understand what this is called? I used to think I knew excel pretty well! Here is a sample formula where it is used along with a number of named ranges/arrays: SUMPRODUCT(--(Planner_Type="I"),--(Planner_Category=Dashboard!$R20),INDIRECT($D$22)) *Filter_Currency_ExchangeRate Hi It's called double unary, it changes "True/False" into 1 and 0's that Sumproduct can use fot its calculation On Thursday, November 15, 2012 12:57:19 PM UTC-8, Cimjet wrote: On Thursday, November 15, 2012 3:16:48 PM UTC-5, IHN Warrior wrote: I am trying to understand a formula and cannot find Excel documetnation on what the "--" (operator ?) means in Excel 2010. Can someone give me a brief explanation and point me to some documentation where I can at least understand what this is called? I used to think I knew excel pretty well! Here is a sample formula where it is used along with a number of named ranges/arrays: SUMPRODUCT(--(Planner_Type="I"),--(Planner_Category=Dashboard!$R20),INDIRECT($D$22)) *Filter_Currency_ExchangeRate Hi It's called double unary, it changes "True/False" into 1 and 0's that Sumproduct can use fot its calculation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel "Sumproduct" Totaling formula? | Excel Worksheet Functions | |||
=IF(B1,"",SUMPRODUCT(--(B$1:B$5=""),--(A1<A$1:A$5))+1), Biff formula | Excel Worksheet Functions | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming | |||
Sumproduct formula "breaks" when referencing too many cells, why? | Excel Discussion (Misc queries) |