Start Free Course
Example 1- step 2

TRUE Excel Function

Written by ExcelMojo Editorial Team ExcelMojo Editorial Team ExcelMojo editorial profile and article credentials. Full Bio
Reviewed by Dheeraj Vaidya, CFA, FRM Dheeraj Vaidya, CFA, FRM Reviewed for accuracy, clarity, and editorial standards. Full Bio
Updated Apr 28, 2026
Read Time 6 min

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.

Frequently Asked Questions (FAQs)

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

📥Download the ready-to-use Excel template to practice this tutorial yourself.

Download Excel Template

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 –