| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Meaning of "--" in formulas
I sometimes see formulas with -- before a set of parenthesis (sample formula
below), can anyone tell me what the purpose of it is? I can't seem to find it documented anywhere. For example: =SUMPRODUCT(--(MONTH(b7:b400)=MONTH(D417)), --(YEAR(b7:b400)=YEAR(D417)) Thanks -- JoAnn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the meaning of the plus sign in "=+A1"? | Excel Worksheet Functions | |||
| What is the meaning of the plus sign in "=+A1"? | Excel Worksheet Functions | |||
| Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
| Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
| In Excel, what is the meaning of " ^ " symbol in a formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
