Thread: What does "--" (2 minus signs) do in a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default What does "--" (2 minus signs) do in a formula
It is called "double unary minus" and J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

If this post helps click Yes
---------------
Jacob Skaria


"Huggy" wrote:

I have been given a spreadsheet that works with the following formula included.

SUMPRODUCT(--(INT((MONTH(ROW(INDIRECT($K4&":"&$J4)))+2)/3)=3),--(YEAR(ROW(INDIRECT($K4&":"&$J4)))=YEAR(Q1Start))))

What does the "--" 2 minus signs after sumproduct do?

Thanks
Reply With QuoteReply With Quote