Boolean operators and truth tables Computers use electrical circuits which have two states – on or off. This can also be represented as 1 or 0 or True and False.

Just when you thought you had Boolean logic in the bag, Excel 2013 introduced the new operator XOR, which means Exclusive OR. Think of it as a similar opposite of NOT: If one condition is true and ...

These connect together to form logic gates, which in turn are used to form logic circuits. These can be represented as truth tables, Boolean algebra logic statements, and diagrams.