Thread: What does -- mean in formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
illini_99 illini_99 is offline
external usenet poster
  
Posts: 1
Default What does -- mean in formulas
I have seen formulas that include two -'s. I am not sure what this does. Is
it just a way to add some spacing since two negatives equal a positive?

Example:
=SUMPRODUCT(--(A1:A100=1),--(B1:B100<""))

Reply With QuoteReply With Quote