ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Use of "--" (https://www.excelbanter.com/new-users-excel/209533-use.html)

Sandeep Jangra[_2_]

Use of "--"
 
D'all,
what is the meaning of "--" in a formula.


Mike H

Use of "--"
 
Hi,

The double minus -- or more correctly the double unary coerces logical
values to numeric values of 1 (true) or 0 (False)


formula like SUMPRODUCT can then add these up to obtain the result.

Mike


"Sandeep Jangra" wrote:

D'all,
what is the meaning of "--" in a formula.


Bob Phillips[_3_]

Use of "--"
 
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
__________________________________
HTH

Bob

"Sandeep Jangra" wrote in message
...
D'all,
what is the meaning of "--" in a formula.





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

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