TRUE

• 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:

=TRUE()

1. (optional):
   This function does not take any parameters.

Examples

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

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 as AND, 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.