Excel TRUE Function: Syntax, Examples and Tips

Part of the free Module 5: Excel Formulas and Functions · Function 91 of 105 · Full Excel course

The Excel TRUE function returns the logical value TRUE and takes no arguments. TRUE in Excel is interchangeable with simply typing the word TRUE; the function form exists for compatibility with other spreadsheet programs. Knowing how Excel treats TRUE (as 1 in arithmetic, as a distinct logical type in comparisons) helps you write cleaner IF, IFS and array formulas.

TRUE syntax

=TRUE()

Arguments

ArgumentRequiredMeaning
(none)–TRUE() accepts no arguments. Include the empty parentheses when you use the function form.

The result is the Boolean value TRUE, not the text “TRUE”. In calculations Excel treats TRUE as 1 and FALSE as 0.

Step-by-step example

=IF(A2>100, TRUE, FALSE)
  1. Excel evaluates A2>100.
  2. If it holds, IF returns the logical value TRUE; otherwise FALSE.
  3. The comparison already produces TRUE or FALSE, so =A2>100 gives the same result in fewer characters.

Practical use cases

1. Catch-all condition in IFS

=IFS(B2>=90, "A", B2>=75, "B", TRUE, "C")

Because TRUE is always true, the last pair acts as the default, preventing #N/A.

2. Approximate match flag in VLOOKUP

=VLOOKUP(A2, $D$2:$E$6, 2, TRUE)

TRUE (or 1) asks for the largest value less than or equal to the lookup value; the first column must be sorted ascending.

3. “Show all” option in a filter formula

=FILTER(A2:C100, IF($F$1="All", TRUE, B2:B100=$F$1))

When F1 says All, the include argument becomes TRUE for every row.

4. Convert logical results to numbers

=SUMPRODUCT(--(C2:C100="Delivered"))

The double minus turns TRUE into 1 and FALSE into 0, so the formula counts matches.

5. Data validation that always passes

=TRUE

Useful as a placeholder custom rule while you build a template, to be replaced with a real test later.

6. Checkbox-style flag column

=TRUE()

Fill a “Active” column with logical values so downstream COUNTIF(A:A, TRUE) and conditional formats work without conversion.

Common mistakes and errors

  • Text “TRUE” versus logical TRUE – a cell containing the text string “TRUE” (left-aligned, often imported from CSV) is not equal to the logical value. Convert with =A2=”TRUE” or Paste Special > Multiply.
  • Redundant IF – =IF(test, TRUE, FALSE) equals =test. Simplify.
  • #NAME? – misspellings such as TREU or TRUE(1). The function takes no arguments.
  • SUM ignores logical values – SUM(A2:A10) over TRUE/FALSE cells returns 0. Use SUMPRODUCT(–(A2:A10)) or COUNTIF(A2:A10, TRUE).
  • TRUE=1 comparison – =TRUE=1 returns FALSE because logical and numeric types differ in comparisons, even though TRUE*1 is 1 in arithmetic.

Tips and best practices

  • Write TRUE without parentheses in everyday formulas; TRUE() exists for compatibility only.
  • Use TRUE as the final IFS test to guarantee a default result.
  • Spot text Booleans by alignment: real logical values are centred, text is left-aligned; convert imported columns with =A2=”TRUE”.
  • Coerce with — or N() before summing logical results.
  • Prefer comparisons over IF(test, TRUE, FALSE); the comparison alone returns the Boolean.

Related functions

Frequently asked questions

Does the TRUE function need any arguments?

No. TRUE() takes nothing inside the parentheses. Typing TRUE without parentheses in a formula gives the identical logical value.

How does Excel treat TRUE in calculations?

As 1. TRUE*10 is 10 and SUMPRODUCT(–(range=”x”)) counts matches. In comparisons, however, TRUE is a logical type and TRUE=1 returns FALSE.

What is the difference between the text “TRUE” and the logical value TRUE?

The text is a string of four letters and behaves like any other word; the logical value is a Boolean that IF, AND and OR understand. Imported data often contains the text form and must be converted.

Need a ready-made template? Browse 7,000+ Excel, Power BI and Google Sheets templates at NextGenTemplates.com.