Short Tips#0040: AND, OR, XOR,NOT functions
Tag: XOR
Lesson#86: Logic Gates in Excel
So I show you here how the logic gates can be configured in Excel. AND gate Q = A AND B So here the formula for getting AND result will be =IF(AND(J20=1,K20=1),1,0) NAND gate Q = A NAND B So here the formula for …