How to ☝️ Use the Google Spreadsheets TRUE Function

To use the Google Sheets TRUE function, select a blank cell, go to the Formula bar, type the formula =TRUE(), and press Enter

Take a look at the article below to learn more about the features of the TRUE function and how you can use it effectively!

How to Use the TRUE Function in Google Sheets

Here is a step-by-step guide to help you through the process of using the TRUE function on your worksheet.

Difficulty: Beginner 

Time Estimate: 5 seconds

  1. Click on a blank cell where you want to apply the function.
  2. Move to the Formula bar and enter the formula =TRUE().

How to Use the TRUE Function in Google Sheets

3. Hit the Enter key on your keyboard.

The TRUE Function in Google Sheets

Easy as ABC!

Now that you know how to add this function to your spreadsheet, let’s take a look at the uses of this tool and how you can modify it to fit your needs.

Drilling Down into the TRUE Function

Now let’s see how this function works in detail!

Description

The TRUE function is a logical function that returns the value TRUE.

Purpose

If you want to test a certain condition in your spreadsheet, you might use the TRUE function in conjunction with another function. For example, you could use the TRUE function with an IF statement to check if a certain cell contains the word TRUE.

Syntax

=TRUE()

Arguments

This function does not take any arguments.

Return Value

In this case, the TRUE value will be returned as the result.

Usage Notes

The TRUE function can be useful if you use it in combination with other functions. Use the IF, AND, OR, or NOT functions to get the desired results. 

The IF function

Instead of the =TRUE() formula, you can enter the TRUE word directly into the cell, and the result will be the same.

Instead of the =TRUE() formula, you can enter the TRUE word directly into the cell, and the result will be the same.

Examples

Here we are going to look at how you can combine the TRUE function with others in order to find the TRUE value easily:

  1. Use the IF with the TRUE function.

=IF(A2<100, TRUE()) // Output: TRUE

The IF function

  1. You can also apply the OR function, which will perform the calculation for you and will show you the result.

=IF(OR(A2<100, A3<100, A4<100, A5<100), TRUE()) // Output: TRUE

The OR function

  1. The third function you can use is the AND function.

=IF(AND(A2<100, A3<100, A4<100, A5<100), TRUE()) // Output: TRUE

The AND function

  1. You can also get the TRUE result using the following NOT function.

=NOT(OR(A2<20)) // Output: TRUE

The NOT function

  1. The next function you can use to get the TRUE value is the IFERROR function. 

=IFERROR(A2, TRUE()) // Output: TRUE

The IFERROR function

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning. Daniel loves to learn about new technologies and how they can be applied to solve complex problems. He is also a big fan of productivity hacks and enjoys finding ways to automate tasks to make organizations more efficient.