True Excel Function

Updated on January 2, 2024
Article byTanuj Kumar
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

TRUE Function in Excel

TRUE Excel function is a logical function that does not need any arguments to operate. As it is a TRUE function, the output returned by this function is TRUE. This formula is used by various other conditional functions, such as the IF function, so that if the condition is met, the output returns “TRUE” or returns as “FALSE” when the conditions do not meet.

For example, suppose to “pass” the sales target of employees (B2:B25) is above 100. The TRUE function will be: =IF(B2>100, TRUE()). If the condition is met with the value, it will return the TRUE as output. Else, it will return FALSE as a result.


There is no parameter or arguments used in the TRUE Excel formula.

True Function Formula

How to use TRUE Formula in Excel?

You can understand the TRUE functions working by using the examples below.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

You can download this TRUE Function Excel Template here – TRUE Function Excel Template

Example #1

Use the simple TRUE function in an Excel cell.


True Function Example 1

The output will be TRUE.

Example #2

Let us consider another example of the TRUE Excel function. We can use a TRUE function with other functions as if. Here is an example as follows:


True Function Example 2

If the condition is met with the value, it will return the TRUE as output. It will return False as a result.

Example #3

We can use it to make calculations. For example, we can calculate the following calculations by using TRUE Excel.

True Function Example 3

If the condition is met with the value, it will return the TRUE as output. It will return FALSE as a result.

Example #4

In the example below, we use the TRUE function with the if function in excelIf Function In ExcelIF function in Excel evaluates whether a given condition is met and returns a value depending on whether the result is “true” or “false”. It is a conditional function of Excel, which returns the result based on the fulfillment or non-fulfillment of the given criteria. read more to compare the two-column values.


It would return the TRUE for matched values in columns H and J and return FALSE if the value did not match columns H and J.

Example 4

Example #5

We can use the TRUE function in Excel to check whether the cell value has a certain value or not. We can achieve a simple cell check by using TRUE and IF function details are as follows:


=IF(D55,”Cell has 5″,”Cell does not have  5″)

It will return “Cell has 5” as output if cell D53 has 5 and return the “Cell does not have 5” if the value in D53 does not 5.

Example 5

Things to Remember

  1. TRUE & TRUE() both are unique.
  2. The TRUE() function is used with other functions.
  3. Using TRUE without a bracket may give you the same result.
  4. For calculation purposes, TRUE is a 1, and FALSE is a 0, which we can also use for calculation.
    1. TRUE+TRUE=2
    2. FALSE+TRUE=1
  5. The TRUE function is provided for compatibility with other sheet applications. We may not need it in standard situations.
  6. If we want to enter TRUE, or if we want to provide TRUE as a result in a TRUE Excel formula, we can just put the word TRUE directly in an Excel cell or formula. Excel will return it as the logical value TRUE as output.

For example: =IF (A1<0, TRUE ()), =IF (A1<0, TRUE)

  1. We also need to remember that logical expressions will return automatically TRUE and FALSE as results.
  2. We first used the TRUE function in Microsoft Excel 2007.

Recommended Articles

This article has been a guide to TRUE Function in Excel. Here, we discuss the TRUE Excel formula and how to use the TRUE function in Excel, along with practical examples and downloadable Excel templates. You may also look at these useful functions in Excel: –