Truth Table in Excel
In this application I'm trying to have only 1 positive in a given set so my
truth table would look like this:
x1 y1 z1
1 0 0
0 1 0
0 0 1
If any single response is "1" then all others in that row should be "0". No
two columns should be positive in any one row. Does this clear things up or
muddy the waters further?
--
Thanks,
Jim
"iliace" wrote:
It's been a while since I've studied logic, but don't you need to
define all values of operands for a truth table, and yield the answer
for each using an operator?
In other words, my idea of a truth table is like so, where #(n,m) is
the operator:
X1 Y1 Z1 X1#(Y1,Z1)
0 0 0 0
0 0 1 1
0 1 0 0
0 1 1 1
1 0 0 .... etc.
It's possible to do what you say as far as setting up the table, but I
fail to see how you would actually use it? If you can give an
example, perhaps that would help.
On Jan 7, 11:34 am, JimS wrote:
Good Morning,
I'm trying to incorporate a simple truth table. Basically, if x1=1 then y1
and z1=0, if y1=1 then x1 and z1=0, if z1=1 then x1 and y1 =0. Is there a way
to do this?
--
Thanks,
Jim
|