What does the double minus sign before a forkmula do? (e.g. "--SUM")

  • Thread starter Thread starter shadestreet
  • Start date Start date
S

shadestreet

Just curious, sometime when I ask for help with a formula I am told t
use the "--", and I never really knew what it did.

Thank
 
Hi Shadestreet!

It is used in many counting and summing formulas where a condition
returns TRUE or FALSE and we want to coerce the condition to either 1
or 0. The act of multiplying by -- is the same as multiplying twice
by -1.

Here's a simple example:

=AND(C3=31,C10=28)
Returns TRUE or FALSE

But:

=--AND(C3=31,C10=28)
Returns 1 or 0.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=+SUM 11
What does "--" (2 minus signs) do in a formula 1
minus signs, or dashes in a formula or hyperlink 3
How to remove a - sign after the number 9
How to handle a minus sign "-" as text not as part of a formula? 2
Formatting: Display a minus sign before a number 8
SUM troubleshoot 2
Show "+" (plus) sign when comparing two values 7

Back
Top