How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing


Home >> How to Use Excel Tutorial >> Excel Formulas List >> How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing



In this tutorial, you will learn how to use TRUE and FALSE formulas in excel. These two formulas will produce logic values that you can use for the data processing that needs to use it.

Want to learn how to use important excel formulas faster? Join this Udemy course!

Disclaimer: This article contains affiliate links that might give us commission for each purchase without any additional cost for you. We only put the links we think can help you to optimize your excel use. If you want to read further about this, then please visit our affiliate disclosure page.





TRUE and FALSE Formula Function in Excel

The usability/function of TRUE and FALSE formulas is to produce a TRUE or FALSE logic value in your cell/formula.



Result

The result given by TRUE and FALSE formulas is a TRUE or FALSE logic value.



Excel Version in Which TRUE and FALSE Formulas Can Start to Be Used

You can start to use these two formulas since excel 2003.



The Way to Write Them and Their Input

Generally, the writing of TRUE and FALSE formulas in excel can be illustrated as follows.

TRUE:


=TRUE()


FALSE:


=FALSE()


Simple, isn’t it? These TRUE and FALSE formulas don’t need any input. Just type them like in the illustration above, enter, and your logic values will be produced.


=UPPER(text)


As you can see above, the input needed by this formula writing is just one. It is text, the data you want to change all its letters into uppercase letters.



Example of Usage and Result

The following will give and explain the example of TRUE and FALSE formulas usage and result.

TRUE:

How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of the Example for the TRUE Formula's Usage and Result

FALSE:

How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of the Example for the FALSE Formula's Usage and Result

As you can see from the examples, the way to use TRUE and FALSE formulas is pretty easy.

You just need to type TRUE/FALSE, an open bracket sign, and a close bracket sign. These two formulas don’t need any input so you just need to press enter after you type them. The logic value based on the formula you type will then be given to you.

The same thing also applies if you use a TRUE/FALSE formula in other formulas. You just need to type TRUE() or FALSE() to use their results as the other formulas’ input.



Writing Steps

The following will explain the steps to write TRUE and FALSE formulas. Each step will be explained with the help of an excel screenshot to make you learn it easier.

TRUE:

  1. Type an equal sign ( = ) in the cell where you want to put your TRUE logic value

    How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of Step 1-1

  2. Type TRUE (can be with large and small letters)

    How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of Step 1-2

  3. Input an open bracket sign, followed by a close bracket sign

    How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of Step 1-3

  4. Press enter
  5. Done!

    How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of Step 1-5


FALSE:

  1. Type an equal sign ( = ) in the cell where you want to put your TRUE logic value

    How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of Step 2-1

  2. Type TRUE (can be with large and small letters)

    How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of Step 2-2

  3. Input an open bracket sign, followed by a close bracket sign

    How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of Step 2-3

  4. Press enter
  5. Done!

    How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of Step 2-5


Want to input and process data in excel faster? Use the XLTools Add-Ins! Use our discount coupon code “7C2L8B31AZ” so you can get a 10% discount when you purchase the Add-Ins license!



Alternative 1: Write the Logic Value Directly

If you want, you can also get the same results as the TRUE and FALSE formulas through direct logic value typing. Type TRUE if you want a TRUE logic value and type FALSE if you want a FALSE logic value instead.

See the examples below.

TRUE:

How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of the Example for Writing a TRUE Logic Value Directly

FALSE:

How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of the Example for Writing a FALSE Logic Value Directly

Excel will automatically convert the TRUE/FALSE text you type into a logic value data type.



Alternative 2: Use a Logic Condition

Want to get a logic value directly from a logic condition? You can do that also in excel.

Just type an equal sign before your logic condition in the cell where you want to put the logic value. Excel will automatically evaluate the logic condition and give a TRUE/FALSE result, depending on whether the condition is right/wrong.

In the logic condition you input in excel, you usually need an operator. You use the operator as a connector and evaluator between the first and second values in your logic condition. The often-used operators in excel and their meaning are as follows.

OperatorMeaning
=Equal to
<Less than
>More than
<=Less than or equal to
>=More than or equal to


The logic condition writing that can produce TRUE or FALSE in excel can be seen in the screenshot below.

TRUE:

How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of the Example for Using Logic Condition to Produce a TRUE

FALSE:

How to Use TRUE and FALSE Formulas in Excel: Function, Example, and Writing - Screenshot of the Example for Using Logic Condition to Produce a FALSE

Easy, isn’t it? You just need to type your logic condition in an excel formula format (with the equal sign in front of it). Press enter after you have done typing and the logic value from your logic condition evaluation will be produced.



Exercise

After learning how to use TRUE and FALSE formulas in excel completely, now let’s do an exercise.

Download the exercise file and answer all the questions. Download the answer key file if you have done the exercise and want to check your answers. Or, probably, when you are confused about how to answer!

Link to the exercise file:
Download here

Questions

Answer each question in the gray-colored cell based on the number!
  1. Is the logic condition number 1 TRUE or FALSE? Use the TRUE/FALSE formula to answer it!
  2. Is the logic condition number 2 TRUE or FALSE? Type a logic value text directly to answer it!
  3. Is the logic condition number 3 TRUE or FALSE? Type the logic condition in a formula format to answer it!

Link to the answer key file:
Download here



Additional Note

TRUE and FALSE formulas are compatibility formulas made available by excel to interact with other spreadsheet applications. We usually never use them in a normal data processing.

Want to learn excel faster? Join this Udemy course!

Other formulas you need to learn too:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert