# Excel TRUE Function

Home ➜ Excel Functions ➜ **Excel TRUE Function (Example + Sample File)**

**What is EXCEL TRUE FUNCTION**

The Excel TRUE Function is listed under Microsoft Excel's Logical Functions category. **It returns a logical value TRUE (a boolean).** The TRUE return by the TRUE function is the same as you enter TRUE in a cell manually and it is equivalent to the numeric value 1.

**How to use it**

To learn how to use the TRUE function in Excel, you need to understand its syntax and arguments:

**Syntax**

TRUE()

**Arguments**

- It has no arguments.

**Notes**

- TRUE and TRUE() both are identical.
- TRUE has a value of 0.
- Using TRUE without parentheses will also give you the same result.

**Example**

To master the TRUE function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used TRUE() and TRUE, in the same manner, and both return the same value. You can also use TRUE in the numeric calculation as it has 1 value.

**Hey Listen,**

You can some Excel Basics Tutorials from this page and here we have Top 100 Excel Tricks and Tips for you get better at Excel in no time.

## Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

**About the Author**

**Puneet Gogia**

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

COPYRIGHT © 2020 • EXCEL CHAMPS