Viztab › Formulas › TRUE
Logical

TRUE Formula

TRUE() returns the logical value TRUE. While you can type TRUE directly into a formula, the function form is useful for consistency in programmatic formula construction and when a function explicitly requires a function call rather than a constant.

Syntax

TRUE()
ParameterDescription
Try TRUE in Viztab — free, no signup

Examples

Explicit logical value

Formula
=IF(A1>10, TRUE(), FALSE())
Returns TRUE if A1 exceeds 10. Equivalent to =A1>10 but sometimes clearer in complex nested formulas.

Default in IFERROR

Formula
=IFERROR(VLOOKUP(A1, B:C, 2, TRUE()), "Not found")
Uses TRUE() as the approximate-match argument in VLOOKUP. Returns the lookup result or "Not found" on error.

Common Errors

#NAME?

Occurs if you misspell TRUE (e.g., =TURE()). The function takes no arguments — TRUE(1) is also invalid in strict mode.

Tips

No arguments needed

TRUE() takes zero arguments. You can also just type TRUE without parentheses in most spreadsheet apps.

Numeric equivalent

TRUE equals 1 in arithmetic. =TRUE()+TRUE() returns 2. This is useful for counting logical results with SUM.

Try TRUE in Viztab

Import your data and use TRUE with 370+ other formulas. No signup required.

Open Viztab

Related Formulas

IFERROR Returns value if no error, else alter... AND Returns TRUE if all arguments are TRUE OR Returns TRUE if any argument is TRUE NOT Reverses the logic of its argument XOR Returns TRUE if odd number of argumen... FALSE Returns the logical value FALSE