TRUE Function in Excel: The Logical Value TRUE

TRUE Function in Excel: The Logical Value TRUE 1
⏱ 1 min readUpdated 5 October 2026

LogicalLevel: BeginnerAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. TRUE in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

TRUE() returns the logical value TRUE. You can also just type TRUE; the function form exists for compatibility.

Advertisement

Syntax

=TRUE()

Examples

Example 1

=TRUE()

Result: TRUE. See the worked example table below for more cases.

TRUE in practice

Where you will use it

  • Default arguments (e.g. exact match flags)
  • Testing logic
  • Compatibility with other spreadsheets

Worked example

CheckFormulaResult
Value=TRUE()TRUE
As a number=TRUE()*11
Count TRUEs=SUM(--({TRUE,FALSE,TRUE}))2

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
Typing "TRUE" in quotesThat's text, not logical
Summing logicalsWrap with -- or *1

FALSE · AND · IF

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZSTOCKHISTORY Function in Excel: Historical Share PricesExcel Functions A–ZACOT Function in Excel: Inverse CotangentExcel Functions A–ZSORTBY Function in Excel: Sort by Another Column
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong