Multiple Logical Operators

I am working on a truth table generator that will use multiple Logical operators ( a combination of as many as 15 logical operators ( e.g. And, Or, Not... to solve for a single result.)
The problem I have run into is the result is fine until you start using the NOT operator in the equation.

The next line is the equation out of the code according to the equation any "0" input in the third column should return a result of "1" in the fourth column

= (INPUTval(0) And (Not (INPUTval(1)) Or (Not (INPUTval(2)))))

0 0 0 0
1 0 0 1
0 1 0 0
1 1 0 1
0 0 1 0
1 0 1 1
0 1 1 0
1 1 1 0




When "Not" is used I either get a negative number as a result, or a a wrong result when the equation seems to be written correctly. The code is below. It is a combination of examples off the web and my own doings. any help will be greatly appreciated...

Thanks in advance, Blues

This will be pasted in the Work sheet in the top rows (In Bold)

IN_0 IN_1 IN_2
Min 0 0 0
Max 1 1

Please Login or Register  to view this content.

The closing code tag is [/code], corrected below.

You're using 1s and 0s as your logical values, but to VBA, logical operations are bitwise operations, so Not 1 (and Not is an operator, not a function, in VBA) is -2 (the inversion of all bits).

True and False in VBA are the signed 16-bit integers -1 and 0

First thanks for the reply ,
I think I understand what you are saying...
Then how should the following equation be written

Please Login or Register  to view this content.

where it will produce the correct result

Thanks,Blues

If you change your 1s and 0s to True and False and change the array types to Boolean, it may work. You can get rid of most of the parens:

Please Login or Register  to view this content.