If you want to add boolean values to Google Sheets, you may use the TRUE function, which is an excellent built-in function.
This can come in handy in a variety of situations where you need to include boolean values in your spreadsheet.
The TRUE function is a basic function that returns to your cell the logical value “TRUE.”
The TRUE function’s syntax is as follows:
=TRUE()
You can also type “TRUE” in a cell and Google Sheets will convert it to the logical “TRUE” value, which is the same as using this function.
In a spreadsheet, here’s an example of how TRUE works:
As you can see from the preceding example, this is a very simple function that simply returns TRUE.
One thing to keep in mind is that in Google Sheets, the boolean value TRUE has a numeric value of 1. The numerical value of FALSE is 0. So you can use these boolean values to perform fundamental math operations.
Here is an example of how this works:
How to Use TRUE Function
You may now be asking how this feature will be useful. I’ll demonstrate how to use this function in a few different scenarios.
The TRUE function is typically used in conjunction with other logical functions such as IF, OR, AND, IFERROR, ISNA, and so on.
Let’s look at some examples of how this function can be combined with other logical functions.
Using TRUE with IF
The syntax for using TRUE with IF is as follows:
=IF(logical_expression, true())
This formula will evaluate your expression and return TRUE if it is true, and FALSE if it is false.
An example of how this would be utilised in a spreadsheet is as follows:
As you can see, by including the TRUE function in your calculation, you can get TRUE or FALSE results based on how your expression evaluates.
Using TRUE with OR
If any of a set of conditions is met, you can use OR with TRUE and the IF function to return TRUE.
This is how it would look in a spreadsheet:
The TRUE function has various applications, yet it is unlikely that you would use it every day when working with spreadsheets.
Still, the function has its uses, and knowing how and when to use it is beneficial.