Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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.

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 .