ExcelFlux

TRUE function

the logical value TRUE.

Logical

Where can you use it?

Teams building reports and business rules. Adapt the example’s decision rule when you need to test a condition or display different results based on it.

Scenario in the workbook

Return a logical TRUE constant for conditions and flags.

A worked example from the workbook

RowA
6Value
71
82
93
Record 1
=TRUE()

Expected resultTRUE

See the inputs and instructions for all 3 examples

Syntax

TRUE()

Copyable formulas

English Excel · en-US
=TRUE()
Turkish Excel · tr-TR
=DOĞRU()

Expected result

TRUE

Worked examples

Return a logical TRUE constant for conditions and flags.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Value
7 1
8 2
9 3
Case Formula Expected result
Record 1 =TRUE() TRUE
Record 2 =TRUE() TRUE
Record 3 =TRUE() TRUE
Microsoft Excel reference