No, it is not affected, because the conditional test still returns TRUE or FALSE, EVEN when the values being tested for are -1, 1, or 0. It is the test that needs coercing, not the values (this is a common misconception that you often see in SP formulae, like so
=SUMPRODUCT(--(A2:A20="x"),--(B2:B20="y"),--(C2:C20))
But that will be covered more in part 2 or 3.




Reply With Quote