What Does -- In A Formula Mean?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a formula that looks as follows:

=IF(AND(H20="NEX",$C20="Operations",U$15="Yes"),SUMPRODUCT(--($D$17:$D$228=D20),--($H$17:$H$228="EX"),$T$17:$T$228)/SUMPRODUCT(--($D$17:$D$225=D20),--($H$17:$H$225="NEX")),"")

What is the purpose of the -- in the formula?

Thanks
 
Someone in an Excel newsgroup could probably tell you...

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
You can lead a fish to a bicycle,
but it takes a very long time,
and the bicycle has to *want* to change.
 
Hi Mike,

In most languages it is a decrement operator.

If i = 10 then --i would subtract 1 from i before it is used. If i = 10 then i-- would use i then subtract i

if i = 10 then ++i would increment i by one before using it. If i = 10 then i++ would use i then increment it by 1
 
Back
Top