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.

=A2=B2

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.

=B2>=$G$4

## 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

=(logical test)*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.

=--(logical test)

And the result is the same; the test returns 0 or 1.