Excel can do all the work for you! It has AND and OR functions for prescisely this job.
e.g. =+AND(1,1)=1
I think if you simplify symbolically you just get A.B, but I suggest you check.
What is the Z column for in you spreadsheet? It looks like NOT ( A . B)
Bookmarks