TRUE function
TRUE returns the logical value TRUE. Typing TRUE directly in a cell gives the same value, so the function exists mainly for compatibility and is rarely needed in new formulas.
Example
Read it as a sentence: add the value in F4 and the number 1, where F4 holds TRUE and SUM skips it, which gives 1.
Excel shows 1
F
1
2
'123
3
2024-02-29
4
TRUE
Data
Syntax
TRUE()
TRUE takes no arguments.
Returns: The logical value TRUE.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=TRUE() | TRUE | Function form |
=TRUE | TRUE | Constant form |
=TRUE()+1 | 2 | Arithmetic |
=TRUE()=1 | FALSE | Compared with 1 |
=SUM(TRUE,1) | 2 | Direct arg to SUM |
=SUM(Data!F4,1) | 1 | TRUE in referenced cell |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
2
'123
3
2024-02-29
4
TRUE
Data
Watch out for
- Typing TRUE in a cell gives the same logical value.
Where it works
- Excel
- TRUE is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Logical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .