Not really mate, it is used to coerce True/False arrays into 1/'0 arrays
which can then be summed.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"via135" wrote in
message ...
hi
the double unary "--" which converts text value into numeric
is mostly used for ignoring errors..!!
-via135
WBTKbeezy Wrote:
Hi, can anyone inform me the reason for using the "--" in formulas
(especially the sumproduct function)
Someone referred me to this link but I cannot decipher HOW the formula
works.
http://www.nwexcelsolutions.com/adva...ction_page.htm
(Question 1)
Thanks
--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=549118