Summary

The Excel TRUE function returns the logical value TRUE. It is a small function, but it helps explain how Excel handles logical values and how those values can be used in tests, flags, and simple calculations.

In practice, many formulas produce TRUE automatically, such as =A1>0 or =B2="Yes". The TRUE function is mostly useful when you want to return that value explicitly, or when you want to understand how TRUE behaves inside larger formulas.

Syntax

=TRUE()

The TRUE function takes no arguments. Microsoft also notes that you can type the word TRUE directly into a formula or cell and Excel will understand it. The function form is still useful when you want a clear, explicit formula.

Arguments

• No arguments - TRUE does not take any inputs.

If you see TRUE inside another formula, it is often there as a fixed logical result rather than something being calculated from scratch.

TRUE vs Related Functions

TRUE is simple on its own, so it makes more sense when you compare it with the other logical building blocks around it.

Most of the time, TRUE shows up as the result of another formula rather than as a standalone function. That is normal, and it is one reason this lesson is best understood together with IF, AND, and OR.

Using TRUE

A direct =TRUE() formula is helpful when you want to create a simple logical flag. For example, you might mark a setting as on, temporarily force part of a test to pass, or build a small demo that shows how logical formulas behave. It is not a complicated function, but it can be useful when you want a formula to be very explicit.

TRUE also matters because of how Excel treats it in calculations. In many formulas, TRUE acts like 1 and FALSE acts like 0. That means multiplying a number by TRUE keeps the number the same, while multiplying by FALSE turns it into zero. This is one of the simplest ways to understand boolean math in spreadsheets.

It is also worth separating logical TRUE from the text string "TRUE". If you put TRUE in quotes, Excel treats it as text, not as a logical value. That difference matters when the result will be used in later formulas, filters, or conditional logic.

Example 1 - Return TRUE Directly

This is the most basic use of the function.

=TRUE()

The formula returns the logical value TRUE. This is useful when you want to create a fixed logical flag or test how another formula reacts to a TRUE input.

Example 2 - Get TRUE from a Comparison

Many formulas return TRUE without using the TRUE function directly.

=50=50

This returns TRUE because both sides are equal. It shows that comparisons naturally produce logical results in Excel, which is why TRUE often appears as the output of another formula rather than from =TRUE() itself.

Example 3 - Return TRUE as the Result of an IF Formula

TRUE can also be used as the explicit result of a condition.

=IF(A1<>"",TRUE(),FALSE())

If A1 is not empty, the formula returns TRUE. Otherwise it returns FALSE. In real spreadsheets, this kind of formula can be used to create ready/not-ready, filled/missing, or passed/failed flags.

Example 4 - Use TRUE in Simple Multiplication

This example shows how TRUE behaves in math.

=500*TRUE()

Because TRUE behaves like 1 here, the result stays 500. This is a simple demonstration, but it helps explain why logical values can work inside some numeric formulas.

Conclusion Recap

• Core idea: TRUE() returns the logical value TRUE.
• No inputs: The function takes no arguments.
• Common reality: TRUE is often produced by comparisons and logical functions automatically.
• Math behavior: In many formulas, TRUE behaves like 1.
• Important distinction: TRUE is logical, while "TRUE" is text.
• Best use: Helpful for simple flags, testing, and understanding logical values in Excel.