Logical
TRUE
Definition
TRUE returns the logical value TRUE.
Syntax
=TRUE()
Arguments
| Argument | Meaning |
|---|---|
(none) |
TRUE takes no arguments, but the empty parentheses are still required. |
Worked example
A cafe flags an order as paid when the amount is at least 20. Amounts are in B2:B4.
| A: Order | B: Amount |
|---|---|
| 12 | 25 |
| 13 | 9 |
| 14 | 20 |
Formula: =IF(B2>=20,TRUE(),FALSE())
Result: TRUE. 25 is at least 20, so IF returns TRUE. Filled down, the formula gives TRUE, FALSE, and TRUE.
Practice
Cell B2 holds 1. In C2, write TRUE().
- In C2, write a TRUE formula.
Step 1 of 1
Enter =TRUE() in C2.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
C2 uses TRUE.
Related functions
TRUE is the value IF returns when a test passes, and AND returns TRUE only when every test it receives is true.
Common mistake
Wrapping the result in quotes, as in "TRUE": that is text, so AND and IF do not treat it as the logical value TRUE.