Logical Operator Syntax

[bluesstruggler]

what would the syntax be for the following statement concerning Logical Operators
D= True
IF
NOT "A" AND, NOT "B OR "C" = True
Thanks in advance for the help

Perplexed...

[shg]

That's ambiguous. It could mean =and(not(A1), B1<>C1))

[bluesstruggler]

it is a boolean equation that all three inputs are <> but the two of the inputs are on an OR gate before the AND, and the final output is <>

Thanks

[shg]

but the two of the inputs are on an OR gate before the AND, and the final output is <>

You mean B and C into a NOR gate, and that output and A into an NAND gate?

=AND(NOT(A1), OR(B1, C1))

[bluesstruggler]

Thanks for the reply and your assesemnt is correct.
I have a bunch of boolean equations that I have to make truth tables for, some with as many as nine inputs to one output all with unique gate logic (AND OR NOT < ,> etc.) for each drawing.

I can generate the truth tables with VBA but I want to write one equation that will represent the logic I am solving for in the first cell and then drag the cell to solve for all of the remaining truths. I am not an Excel wiz and am struggling with the nested operator format , I have over a hundred pages of logic to solve for and I am looking for the best way to do it. After beating my head against the wall this it the best tool I can come up with? I am open to suggestions as well

Thanks again for your input, Blues