Double hyphens --
It's double unary. It, in this case, forces a TRUE or FALSE argument into a
numerical value of 1 or 0. If you do a search for double unary, you might
find some better explanations, but essentially, it takes a text argument and
converts it (if able) into a numeric argument.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.
"SteveM" wrote:
What does a double hyphen do in a formual?
e.g. =SUMPRODUCT(--(Sheet2!$A$2:$A$100=$A2),--(Sheet2!$H$2:$H$100="H98"))
I saw that as a response in a different post, and I've seen the "--" in
other responses but have not been successful in finding it in help
|