| 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 |
| 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) | |||
Threaded Mode
