Generate a truth table in excel with certain boolean expressions

Viewed 29

Im trying to make a truth table that finds Q e.x (A^B)~^(~C)=Q. or. (A~⊕B)^C=Q the formula I've come up with to solve for q with xnor is =NOT(XOR(A2:B2)) "(A~⊕B)^C=Q" but want to include AND C in the equation "(A~⊕B)^C=Q"

Something like this but more complex

1 Answers

I am not sure if I understood your question, but if what you want is: AND (NOT(XOR(A,B)), C). I tested that XOR provides the same result for {TRUE, FALSE} values as for {0,1} even XOR documentation doesn't specify this case. I tested the result in both cases for all possible combinations and check the result:

=NOT(XOR(A3,B3))*C3

screenshot with the solution

Here is a link to my sample file.

Related