NAND

  • Thread starter Thread starter Hans Knudsen
  • Start date Start date
H

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
 
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)
 
Back
Top