Understanding TRUE and FALSE in Excel (Boolean Values)

Last Updated: December 30, 2023
puneet-gogia-excel-champs

- Written by Puneet

TRUE and FALSE are the Boolean values. Both values represent a result of a condition. For example, 1 = 1 is TRUE, and 1 = 2 is FALSE. In both cases, we have a Boolean value which helps you understand the result. These are also called truth values.

In Excel, there are two ways to use these Boolean values.

  • You enter them in a cell.
  • You get them in return as a result.

In most cases (while working in Excel), you do not need to enter them in a cell manually. And there are further multiple ways that you can use to get TRUE and FALSE in a cell as a result.

TRUE and FALSE are equivalent to 1 and 0, respectively.

Use TRUE and FALSE Functions

You have two specific functions in Excel, TRUE, and FALSE, to get both Boolean values.

true-or-false-in-excel

In these functions, you don’t need to specify any argument within the function.

=TRUE()
=FALSE()

Get the Result by Testing a Condition

When you test a condition, the result is always in TURE or FALSE. And these are the situations where you deal with TRUE and FALSE a lot in Excel. If you test 1 = 1, your formula returns TRUE.

formula-returns-true

But if you test 1 =2, your formula returns FALSE.

formula-returns-false

TRUE and FALSE are the basics to express the result of a condition in Excel. Even though the IF function in Excel also works with TRUE and FALSE.

true-and-false-express-the-condition-result

The entire work in the IF function is based on the TRUE and FALSE values.

Using Logical Operators

In Excel, you have logical operators, which help you get test conditions. These logical operators also return results in TRUE and FALSE values.

use-logical-operations

Even when testing test values with each other, we get the result in TRUE or FALSE.

Converting TRUE-FALSE as 1-0

There are two ways to convert the Boolean values into 0 and 1.

  • N Function
  • Double Minus Sign
convert-true-false

In the above example, we first used the function N and then the double minus sign (–), and both converted TRUE and FALSE into 1 and 0.

Out of both methods, using a double minus sign has little benefit. For example, if you want to count the cells with the TRUE, you can use it along with the SUM.

converted-true-and-false-into-1-and-0

Get the Excel File