Home » Function » Condition » Convert TRUE or FALSE to 1 or 0

Convert TRUE or FALSE to 1 or 0

Reading time: 2 minutes
Last Updated on 11/11/2022 by Frédéric LE GUEN

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.

=A2=B2

Test to compare the value of 2 columns

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.

=B2>=$G$4

Age Greater than 21

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

=(logical test)*1

Convert logical test by multiply 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.

=--(logical test)

Convert logical test with 2 dashes

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

Leave a Reply

Your email address will not be published. Required fields are marked *

Convert TRUE or FALSE to 1 or 0

Reading time: 2 minutes
Last Updated on 11/11/2022 by Frédéric LE GUEN

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.

=A2=B2

Test to compare the value of 2 columns

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.

=B2>=$G$4

Age Greater than 21

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

=(logical test)*1

Convert logical test by multiply 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.

=--(logical test)

Convert logical test with 2 dashes

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

Leave a Reply

Your email address will not be published. Required fields are marked *