Basic logical test in Excel
In Excel, any logical test returns TRUE of FALSE.
For instance, to compare the contains of 2 columns, you have to write the following test.
In this second example, we want to know if our customer have 21 years-old or more. So we create the following test with an absolute reference to the limit cell.
How to convert the test to a numeric value?
So when you create a test in Excel, the result is TRUE or FALSE by default.
Tips 💡And the result is always displayed in the center of the cell, ALWAYS 😉
But, you can convert TRUE or FALSE to 1 or 0 with 2 different method
Method 1: Multiply by 1
The first method is to multiply the logical test by 1
You can see in column D the formula used
Method 2: Write 2 dashes
The other technique is to write 2 dashes before the test like in this example.
And the result is the same; the test returns 0 or 1.