TRUEformula 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
- Examples of using
TRUEformula not working?
- Similar formulas to
TRUE formula with the syntax shown below, it has 1 optional parameter:
This function does not take any parameters.
ExamplesHere are a few example use cases that explain how to use the
TRUEformula in Google Sheets.
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.
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.
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.
TRUEnot working? Here are some common mistakes people make when using the
TRUEGoogle Sheets Formula:
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().
The formula must include parentheses, even if it does not require any arguments. Make sure to include the parentheses when writing TRUE().
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.
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.
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'.
The following functions are similar to
TRUE or are often used with it in a formula:
FALSEformula returns the logical value of FALSE. It is often used in conjunction with other logical formulas or as a placeholder value.
ANDfunction 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.
ORformula 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.
NOTformula 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.
You can learn more about the
TRUE Google Sheets function on Google Support.