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
| Argument | Required | Meaning |
|---|---|---|
| (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)- Excel evaluates A2>100.
- If it holds, IF returns the logical value TRUE; otherwise FALSE.
- The comparison already produces TRUE or FALSE, so
=A2>100gives 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
=TRUEUseful 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
- FALSE – the opposite logical constant.
- NOT – inverts TRUE and FALSE.
- IF, AND and OR – produce and consume logical values.
- ISLOGICAL – checks whether a cell holds TRUE or FALSE.
- Browse the Excel Formulas hub or watch videos on YouTube.com/@PKAnExcelExpert.
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.