-- in Formulae

F

Frank Kabel

Hi
this is a double minus (unary operator) and is othen used to coerce
boolean values (TRUE/FLASE) to numeric values (1/0)
 
C

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Cannot access to Office Insider 0
Autonumber field in Excel that behaves the same as Access 0
Newbie Help - IF Yes No Function 0
Checkboxes and Cell Color 3
MS Project. Real progress of the project, % complete 1
Expanding Date Formula 0
Display weeks from a Milestone 0

Top