Based on the Boolean logic in Excel, all mathematical expressions will simplify to 0 (FALSE) or 1 (TRUE) values.
For the sake of simplicity, let us see an example, how to convert Excel a math operation TRUE and FALSE values into 1’s and 0’s. There are only two types of output: 0 or 1.
Boolean logic example
In the following example you want to filter products using the criteria below:
The expression is TRUE if the price in cell C3 is greater than 100 and it is in stock:
=(C3>100) * (D3=”Yes”)
Boolean logic reduces the formula to =TRUE * TRUE
Finally, Excel converts the result to =1*1 =1
Using boolean expressions you can simplify formulas.
The formula above is equivalent to:
=IF(AND(C3>100, D3=”stock”),1,0)
Additional resources: