When does TRUE evaluate to minus 1?

[davidm]

I want to exploit the fact TRUE equtes to -1 but cannot get my head around the conditions surrounding this. I have experimented in code with MsgBox (5=(50/10)) , or some such direct equality , but each time simply get the result TRUE.

How can I wrest minus 1 from a TRUE boolean relationship?

[TommySzalapski]

Convert the bool to and integer

CInt(True) = -1

CInt(5=5) = -1

CInt(5=4) = 0

[davidm]

Thanks Tommy. Exactly what I am lookoing for.

[Tom Ogilvy]

msgbox "the column is " & _
Left(ActiveCell.Address(0,0), 2 + (ActiveCell.column < 27))

would be an example of exploiting True is equivalent to -1

--
Regards,
Tom Ogilvy

"davidm" <[email protected]> wrote in
message news:[email protected]...
>
> I want to exploit the fact TRUE equtes to -1 but cannot get my head
> around the conditions surrounding this. I have experimented in code
> with MsgBox (5=(50/10)) , or some such direct equality , but each time
> simply get the result TRUE.
>
> How can I wrest *minus 1* from a TRUE boolean relationship?
>
>
> --
> davidm
> ------------------------------------------------------------------------
> davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
> View this thread: http://www.excelforum.com/showthread...hreadid=390606
>

[Chip Pearson]

You can either use CInt to convert it to an integer, or do some
arithmetic with it. E.g.

Dim Res As Integer
Res = CInt(5 = (50 / 10))
Debug.Print Res
' or
Res = (5 = (50 / 10)) + 0
Debug.Print Res


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"davidm" <[email protected]>
wrote in message
news:[email protected]...
>
> I want to exploit the fact TRUE equtes to -1 but cannot get my
> head
> around the conditions surrounding this. I have experimented in
> code
> with MsgBox (5=(50/10)) , or some such direct equality , but
> each time
> simply get the result TRUE.
>
> How can I wrest *minus 1* from a TRUE boolean relationship?
>
>
> --
> davidm
> ------------------------------------------------------------------------
> davidm's Profile:
> http://www.excelforum.com/member.php...o&userid=20645
> View this thread:
> http://www.excelforum.com/showthread...hreadid=390606
>