TRUE Function

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.

TRUE is a small function, but it can make boolean intent more explicit. In formulas, demos, and training examples, it helps show that a result or argument is deliberately logical, not just text that happens to read like a yes-value.

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 example returns the logical value TRUE directly, with no condition wrapped around it. It helps show that TRUE is a real Excel value that formulas can use, not just a displayed word.

That can be useful when you want to set a fixed logical flag or test how another part of the worksheet responds to a TRUE input.

=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

This example shows the more common way TRUE appears in spreadsheets: as the result of a comparison. Excel checks the statement and returns TRUE because both sides match.

That makes logical results feel more natural, because they are often produced by everyday checks rather than by typing TRUE() on its own.

=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

Here, TRUE is being returned by an IF formula when the condition passes. The result becomes a simple status flag based on whether the cell contains something.

This is a common pattern when later formulas, filters, or dashboard checks need a clean TRUE/FALSE result to work from.

=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 matters because logical values can also take part in numeric formulas. In this kind of math context, TRUE behaves like 1.

That helps explain why logical tests can sometimes be multiplied or added in more advanced spreadsheet patterns.

=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

TRUE() is another small function that matters mostly because of how Excel treats logical values. In this lesson, it appeared as a direct output, as the result of comparisons, and as part of simple boolean math.

The main idea is that TRUE is not text. It is a logical value, and in many calculations Excel treats it like 1.

• 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.