-- in Formulae

  • Thread starter Thread starter Dustin
  • Start date Start date
Hi
this is a double minus (unary operator) and is othen used to coerce
boolean values (TRUE/FLASE) to numeric values (1/0)
 
Dustin,

The -- is the same as multiplying what follows by -1 twice. It
is used to change comparisons which return TRUE or FALSE to their
numeric equivalents of 1 and 0.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top