View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike
 
Posts: n/a
Default What Does -- Mean In A Formula

I have a formula that looks as follows:

=IF(AND(H24="NEX",$C24="Operations",U$15="Yes"),SU MPRODUCT(--($D$17:$D$228=D24),--($H$17:$H$228="EX"),$T$17:$T$228)/SUMPRODUCT(--($D$17:$D$225=D24),--($H$17:$H$225="NEX")),"")

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