Exceljet

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:

=(C5>80)*(D5="red")
=(TRUE)*(TRUE)
=1

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:

=IF(AND(C5>80,D5="red"),1,0)

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