These instructions apply to Excel versions 2019, 2016, 2013, 2010, and Excel for Microsoft 365.

What is a Boolean Value?

The argument must always evaluate a condition that can only ever result in aTRUEorFALSEresponse.

Binary code

KTSDESIGN/SCIENCE PHOTO LIBRARY / Getty Images

Such formulas automatically setTRUEequal to1andFALSEequal to0.

Screenshot of Excel showing Boolean formulas

Screenshot of Excel showing COUNT function example

Screenshot of Excel showing conversion of BOOLEAN values