NAND

[Hans Knudsen]

Hello
I am just curios to know why it is that

=NOT(AND(TRUE, TRUE)*1 = 0
whereas
= -(TRUE*TRUE)*1 = -1

I am aware that in VBA -1 (all bits 1) means TRUE.

Hans Knudsen

 

[Frank Kabel]

Hi Hans
=NOT(AND(TRUE, TRUE)*1
is the same as
=NOT(TRUE)*1
is the same as
=FALSE*1 = 0*1 = 0

-(TRUE*TRUE)*1 = -(1*1)*1 = -1

Note: Within worksheet functions TRUE evaluates to '1' (and not to -1)