- Jun 30, 2008
- Office Version
I was fiddling around with some coding and noticed something odd... In VBA, if you try to multiply a TRUE statement by 1 to coerce it into a numeric format, it returns a -1 instead of a +1. My initial thought was to eliminate an IF statement by directly using the boolean TRUE/FALSE and multiplying by 1 to store a 1 or 0 in a cell. I do know that a simple fix would be to multiply it by a -1, but I was curious if anyone knew why this happens.