Quick, clean, and to the point

Boolean logic

Example of formula using boolean logic

Boolean logic refers to a technique of building formulas to take advantage of the fact that TRUE = 1, and FALSE = 0.  In Excel any math operation will coerce TRUE and FALSE values into 1's and 0's.  In the example shown:


Boolean logic can be used to simply formulas and eliminate the branching seen in nested IF formulas. In the example the formula in E5 is equivalent to:


For another practical example of boolean logic, see INDEX and MATCH with multiple criteria.