How to convert the result of a test, TRUE or FALSE, by the value 1 and 0
Basic logical test in Excel
In Excel, any logical test returns TRUE or FALSE.
For instance, to compare the contents of 2 columns, you have to write the following test.
In this second example, we want to know if our customer has 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 💡The result of a logical test 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.