fx
FunctionPedia
Quick Answer

TRUE Function

Returns the logical value TRUE.

✓ Excel✓ Google SheetsExcel All versions

Syntax

TRUE
()

Basic Example

Return a TRUE value

=TRUE()
ResultTRUE

The function evaluates to the logical constant TRUE with no input needed.

Advanced Examples

Example 1: Use inside a condition

Force a branch of an IF

Return TRUE from a formula

=IF(TRUE(),"Yes","No")
Result: Yes
Because TRUE() is logical TRUE, the IF returns its value_if_true.

Example 2: Explicit boolean in a check

Compare a cell to a target

Return TRUE on a match

=IF(A1=10,TRUE(),FALSE())
Result: TRUE when A1 equals 10
Returns the explicit TRUE/FALSE constants instead of relying on implicit coercion.

How TRUE Works

TRUE is a function wrapper around the TRUE logical constant. It performs no computation and accepts no arguments; it is provided for compatibility and explicit boolean building.

1
Type the function
Enter =TRUE() with empty parentheses.
2
Use the result
Reference it in logical tests like IF or AND.

Important Notes & Limitations

  • Takes no arguments; supplying any returns #VALUE!.

  • Mostly redundant because the literal TRUE works the same in formulas.

  • Stored as a logical value, not the text "TRUE".

Common Errors & Fixes

#VALUE! errorPassing an argument such as =TRUE(1).

Fix: Leave the parentheses empty: =TRUE().

Download Practice File

Practice TRUE with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the TRUE function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Frequently Asked Questions

Is TRUE() different from typing TRUE?
No, =TRUE() and the constant TRUE behave the same in calculations.
Can TRUE take arguments?
No; it returns #VALUE! if you supply any.
What type is the result?
A logical (boolean) value, not text.