ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Quick question: What does "--" in an equation do? (https://www.excelbanter.com/excel-worksheet-functions/33363-quick-question-what-does-%22-%22-equation-do.html)

Flutie99

Quick question: What does "--" in an equation do?
 
nm


I've just answered that for you in your previous quote! Patience!

Andy.

"Flutie99" wrote in message
...
nm




bj

for items with a logical component
(B1=C1)
the relsult is a true or false
the "--" makes it be a numeric 1 or 0 so that it can be used in equations
most formulas will do the conversion for you, but not all.
Many of us just get into the habit of always using it so that we don't have
to remember what formula does what.

"Flutie99" wrote:

nm



All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com