View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alfred[_5_] Alfred[_5_] is offline
external usenet poster
 
Posts: 1
Default What is the "--" (double dash) in MS Excel formula?

I would like to know the meaning of "--" (double dash) in the below Excel formula:

========= start of formula =================
=SUM(OFFSET(Source!$C$4:$C$425,,,MATCH(0,--(MMULT(--(ROW(OFFSET($A$1,,,ROWS(Source!$C$4:$C$425)))=COL UMN(OFFSET($A$1,,,,ROWS(Source!$C$4:$C$425))))-0.5*(ROW(OFFSET($A$1,,,ROWS(Source!$C$4:$C$425)))= COLUMN(OFFSET($A$1,,,,ROWS(Source!$C$4:$C$425)))), OFFSET(Source!$C$4:$C$425,,,ROWS(Source!$C$4:$C$42 5))+0)SUM(Source!$C$4:$C$425)*ROWS($C$4:$C5)/4))))-SUM(OFFSET(Source!$C$4:$C$425,,,MATCH(0,--(MMULT(--(ROW(OFFSET($A$1,,,ROWS(Source!$C$4:$C$425)))=COL UMN(OFFSET($A$1,,,,ROWS(Source!$C$4:$C$425))))-0.5*(ROW(OFFSET($A$1,,,ROWS(Source!$C$4:$C$425)))= COLUMN(OFFSET($A$1,,,,ROWS(Source!$C$4:$C$425)))), OFFSET(Source!$C$4:$C$425,,,ROWS(Source!$C$4:$C$42 5))+0)SUM(Source!$C$4:$C$425)*ROWS($C$4:$C4)/4))))
========= end of formula =================

Thanks.