TRUE Excel Function

What Is TRUE Function In Excel?

The TRUE Excel function always returns only one of the BOOLEAN values, i.e., “True”, as the output. It is used with conditional functions such as IF(), ERROR(), etc. to get an alternate or a conditional output.

The TRUE Function in Excel is an inbuilt logical function in Excel, so we can insert the formula from the “Function Library” or enter it directly in the worksheet.

For example, we will apply the TRUE function to calculate the logical condition.

Enter the formula =TRUE in cell A2 and =TRUE() in cell A3, and press “Enter.

TRUE Excel Function Intro

The results are returned as ‘TRUE’, as shown above. Column B is for our reference.

Key Takeaways
  • The TRUE Excel Function returns the value “TRUE” as the output.
  • The function helps us to understand whether a given condition is true or not when we use it within the formulas or other Excel functions such as IF(), ERROR(), etc.
  • Excel has a default value for “TRUE” as 1, and for “FALSE” as 0. So, we perform arithmetic or numeric calculations for the function with the default values.
    For ex, =True+11 is 1+11 = 1.
  • The TRUE function is used with or without a bracket. The result will be the same, as the function doesn’t accept any arguments.

TRUE() Excel Formula

The syntax of the TRUE Excel formula is,

True Formula


The function takes no argument and always returns the logical value, i.e., TRUE.

How To Use TRUE Excel function?

We can use the TRUE Excel function in 2 methods, namely,

  1. Access from the Excel ribbon.
  2. Enter in the worksheet manually.

Method #1 – Access from the Excel ribbon

First, choose an empty cell – select the “Formulas” tab – go to the “Function Library” group – click the “Logical” option drop-down – select the “TRUE” function, as shown below.

TRUE Excel Function -formula

 The “Function Arguments” window appears. As the function takes no argument, click “OK”, as shown below.

TRUE Excel Function -arguments

Methods #2 – Enter in the worksheet manually

  1. Select an empty cell for the output.
  2. Type =TRUE() or =TRUE in the selected cell. [Alternatively, type “=T” and double-click the TRUE function from the list of suggestions shown by Excel.]
  3. Press the “Enter” key.

#Basic Example

We will calculate the logical condition of the given data using TRUE and the IF excel function.

In the table, the data is,

  • Column A: contains Condition.
  • Column B: contains Output.
TRUE Excel Function - Basic example

The steps to find the value of the condition using TRUE Excel function are,

  1. Select cell B2, enter the formula =IF(A2>0,TRUE()), and press the “Enter” key. The result is “TRUE”, as shown below.


    Basic example-step 1

  2. Drag the formula from cell B2 to B4 using the fill handle.


    True excel Function -basic example - step 2

The output is shown above. The results are as per the condition of the IF() function.

Examples

We will understand some advanced scenarios using the TRUE Excel function examples.

Example #1

We will calculate the logical condition of the given data using the TRUE Excel function and the IF() function.

In the table, the data is,

  • Column A: contains Value1.
  • Column B: contains Value2.
  • Column C: contains Output.
TRUE Excel Function Example 1

The steps to find the conditional output using the TRUE function are,

1: Select cell C2, enter the formula =IF(A2=B2,TRUE()), and press the “Enter” key. The result is “TRUE”, as shown below.

Example 1- step 1

2: Enter the formulas as follows, =IF(A2>B3,TRUE()) in cell B3, =IF(A2<B3,TRUE()) in cell B4, =(10>1) in cell B4, and =(10>1) in cell B5. Press the “Enter” key every time the formula is entered.

Example 1- step 2

The output is shown above. Column D is for our reference.

Example #2

We will calculate the logical conditions of the given data without the TRUE function by entering the given values as formulas to get either “TRUE” or “FALSE”, as per the conditions.

In the table, the data is,

  • Column A: contains Condition.
  • Column B: contains Output.
Example 2

The procedure to find the logical values of the given conditions are,

Enter the formulas as follows, =(10=10)in cell B2, =(10>1) in cell B3, =(10<100) in cell B4, and =(10<>100) in cell B5. Press the “Enter” key every time the formula is entered.

Example 2 - step 1

We will get the output shown above.

Example #3

We will perform some arithmetic expressions with the TRUE function and calculate the logical conditions.

In the table, the data is,

  • Column A: contains Condition.
  • Column B: contains a Formula that explains the expressions used in the example.
Example 3

The procedure to find the logical values of the given conditions are,

Enter the formulas as follows, =TRUE*10 in cell A2, =TRUE/1 in cell A3, =TRUE-1 in cell A4, and =TRUE+1 in cell A5. Press the “Enter” key every time the formula is entered.

Example 3 - step 1

The results are shown above. Column B is for our reference.

Important Things To Note

  • The logical expressions will automatically return TRUE and FALSE as results.
  • The TRUE function was introduced in Microsoft Excel in 2007. For calculation purposes, the default value of TRUE is 1, and FALSE is 0.
    • TRUE+TRUE=2
    • FALSE+TRUE=1
  • We also can perform arithmetic calculations with TRUE() like: TRUE() * 8  = 8
  • If we want to enter TRUE, or if we want TRUE as a result in a TRUE Excel formula, just type TRUE directly in the cell. Excel will return it as the logical value TRUE as output.

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

Frequently Asked Questions

1. What does the TRUE function do in Excel?

The TRUE Excel Function is the Boolean logical function that returns TRUE, which is equal to 1, as an output. The function is equivalent to directly using the Boolean value TRUE in a formula.

The syntax of the TRUE Function in Excel is =TRUE().

2. How does the TRUE function work in Excel?

We can work with the TRUE function as follows:

1. Select an empty cell for the output.
2. Type =TRUE() or =TRUE in the selected cell. [Alternatively, type “=T” and double-click the TRUE function from the list of suggestions shown by Excel.]
3. Press the “Enter” key.

3. Where is the TRUE Function in Excel?

We can insert the Excel TRUE Function as shown below:

Choose the empty cell which will contain the result.
Go to the “Formulas” tab and click it.
Select the “Logical” option from the drop-down menu.
Select “TRUE” from the menu.
A window called “Function Arguments” appears.
This function takes no argument and returns the logical value TRUE.
Select OK.

TRUE Excel Function -formula

Download Template

This article must help understand the TRUE Excel function’s formula and examples. You can download the template here to use it instantly.

This has been a guide to True Excel Function. Here we explain how to use TRUE excel formula along with examples and downloadable excel template. You can learn more from the following articles –

Reader Interactions

Leave a Reply

Your email address will not be published.