TRUE
TheTRUE
formula is a logical function that returns the boolean value of true. It is commonly used in conjunction with other logical functions to build more complex formulas.
 How to use
TRUE
formula?  Examples of using
TRUE
formula TRUE
formula not working? Similar formulas to
TRUE
Usage
Use the TRUE
formula with the syntax shown below, it has 1 optional parameter:
 (optional):
This function does not take any parameters.
Examples
Here are a few example use cases that explain how to use theTRUE
formula in Google Sheets.
Testing formulas
One use case for the TRUE
formula is to use it in testing other formulas. For example, you might use =IF(A1>B1,TRUE,FALSE)
to test whether the value in cell A1 is greater than the value in cell B1.
Filtering data
Another use case for the TRUE
formula is in filtering data. You can use =FILTER(A1:A10,B1:B10=TRUE)
to filter the data in column A based on a condition in column B. In this case, the formula will return all values where the corresponding value in column B is true.
Conditional formatting
You can also use the TRUE
formula in conditional formatting. For example, you might use =A1=TRUE
to apply a formatting rule to all cells where the value is true.
Common Mistakes
TRUE
not working? Here are some common mistakes people make when using the TRUE
Google Sheets Formula:
Incorrect capitalization
The formula must be written in all caps, otherwise it will be interpreted as a named range or a function that does not exist. Make sure to use all caps when writing TRUE().
Missing parentheses
The formula must include parentheses, even if it does not require any arguments. Make sure to include the parentheses when writing TRUE().
Using quotes
Do not enclose TRUE in quotes, as this will be interpreted as a string and not as a logical value. Make sure to write TRUE() without quotes.
Using numbers
Do not confuse the logical value TRUE with the number 1. TRUE is a Boolean value, while 1 is a numeric value. Make sure to write TRUE() instead of 1.
Using text
Do not confuse the logical value TRUE with the text 'true' or 'True'. TRUE is a Boolean value, while 'true' or 'True' are strings. Make sure to write TRUE() instead of 'true' or 'True'.
Related Formulas
The following functions are similar to TRUE
or are often used with it in a formula:

FALSE
The
FALSE
formula returns the logical value of FALSE. It is often used in conjunction with other logical formulas or as a placeholder value. 
AND
The
AND
function in Google Sheets is a logical function that returns TRUE if all of the logical expressions in the argument are TRUE, and FALSE if any of the logical expressions are FALSE. It can be used to test multiple conditions and evaluate whether they are all true or not. 
OR
The
OR
formula is a logical formula that returns TRUE if at least one of the provided logical expressions is TRUE. It returns FALSE if all logical expressions are FALSE. This formula is commonly used in conjunction with other logical formulas, such asAND
, to build more complex logical statements. 
NOT
The
NOT
formula in Google Sheets is a logical function that negates a given logical expression. If the logical expression evaluates to TRUE, the formula returns FALSE, and vice versa. This function is commonly used to reverse the result of a logical test, or to check if a value is not equal to a specific criteria.
Learn More
You can learn more about the TRUE
Google Sheets function on Google Support.