Generally, **TRUE **or **FALSE **are two logical expressions representing **1** and **0** respectively. On that note, if we want to check whether the given condition is true or false, then we can use Excel’s built-in logical function called “**TRUE**.” In Excel, there are so many logical functions available. For your information, the TRUE function comes under the compatibility function.

Because it will do compatibility tests. In this tutorial, we will let you know how to use Excel TRUE function in Excel with proper examples and scenarios. Get an official version of** MS Excel** from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Jump To

## What is TRUE Function?

TRUE is one of the built-in functions in Microsoft Excel. We all know that TRUE is a logical expression that helps to return the value TRUE in the worksheet. We can use this function in various ways in the spreadsheet. In Excel, we can use it to check whether the given condition is TRUE or FALSE.

### Syntax:

**=TRUE()**

### Arguments:

- This function doesn’t have any arguments.

### Motive:

- It helps to return a logical value
**TRUE**or**FALSE**.

### Return Value:

- We will get
**TRUE**or**FALSE**based on the given statement.

## What Will TRUE Function Do?

As we said earlier, the TRUE function returns the logical expression TRUE or FALSE based on the given statement. This function is categorized as “**Logical**” in Excel. In order to use this function, we can give a value or a formula to check for the statement.

For instance, we have come up with a list of people working in an organization with their ages. From that list, we want to check who is **older than 35**. We want to get **TRUE **as output if **people are older than age 35**, **otherwise**, it will **return FALSE** as output. In order to give it as a condition or statement, we are going to use the IF function.

Now, we will **get **the **boolean expression** (**TRUE or FALSE**) based on the given statement. For that, we need to apply the following formula.

**=IF(C3>35, TRUE())**

Now, **click **on the **Enter **button to execute it and get the result. In the below image, we will get the output value as “TRUE” because the given statement is satisfied.

To fill down the remaining cells, we just need to drag down the first cell. It will automatically refill the below cells one after the other.

We hope that the given scenario helped you to understand the TRUE function. If still you have any confusion, then move to the below section, where we will show you a simple example.

## Alternate Examples

Let’s see a simple example to know how to use the TRUE function in the spreadsheet.

- The following screenshot has shown the list of students’ marks and we want to categorize them as TRUE or FALSE. Here TRUE represent “
**Pass**” whereas FALSE represents “**FAIL**.” - To calculate this condition, we will use the IF function.

- In order to get the result, we need to
**apply the following formula**.

**=IF(C3>40,TRUE())**

- Once you have entered the formula,
**hit**the**Enter**button to get the result, as shown in the below screenshot.

- To fill the remaining cells, you need to drag down the first cell. It will automatically fill the below values in the range.

By doing so, you can easily get the specific value for the replacement of the TRUE error in Excel. Hope it is easy for you.

## Citations

We have referred to the below-mentioned articles to fully understand the purpose of the Excel TRUE function. They helped us a lot. You can also check out them using the given links: TRUE function** ^{[1]}**, IF Function

**.**

^{[2]}- https://www.deskbright.com/excel/true-false-excel/
- https://www.javatpoint.com/how-to-use-the-if-function-in-excel

## Conclusion

With the help of the given scenarios and examples, you can easily understand the **purpose of the TRUE function** **in Excel** and how to apply it in the spreadsheet. The screenshots help to learn it even easier. Share your **suggestions** in the below comment section. Thanks for visiting **AawExcel**. Keep Learning!!

If you want to know what people think about this TRUE Function of Excel, then we suggest you look for it on the Quora interaction webpage. From where you can get to know more regarding the Excel TRUE function. Here, we have provided the link to Quora’s official website.

## Video Tutorial

The following video will show you how to use the Excel TRUE function in the spreadsheet with proper examples.

**More Logical Functions for you:**