EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Logical Functions in Excel Tutorial TRUE Function in Excel
 

TRUE Function in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated August 19, 2023

true function in excel

 

 

TRUE in Excel (Table of Contents)
  • TRUE Function in Excel
  • TRUE Formula in Excel
  • How to Use TRUE Function in Excel?

TRUE Function in Excel

A TRUE function is a logical function that returns the value TRUE. In Excel, we want that output to produce a true value while calculating or applying any condition. In these scenarios, we use a TRUE function, the built-in function in Excel.

It is a useful function when you want to return the output as TRUE based on a condition. A TRUE function is the same as a Boolean value TRUE. It’s also called a conditional function.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

A TRUE function can be used with other logical functions like IF, ERROR, etc.

TRUE Formula in Excel:

Below is the TRUE Formula.

true formula in Excel

This function doesn’t require any argument.

A TRUE function can be used in two ways:

  • =TRUE without parentheses. This will also return the logical value TRUE.
  • =TRUE() which returns the logical value TRUE.

How to Use the TRUE Function in Excel?

A TRUE function is a worksheet function. This TRUE function is very simple and easy to use. Let us now see how to use a TRUE function with the help of some examples.

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

Example #1

TRUE and TRUE() give the same result, and we can use both and vice-versa.

True Function Example 1

Example #2

Now we will see the use of a TRUE function with an IF function. We want to check if the below values are greater than 30.

True Function Example 2-1

For this, we will use the below condition:

=IF(A12>30,TRUE())

True Function Example 2-2

The output will be:

True Function Example 2-3

Drag & drop this formula for all values. The result is shown below:

True Function Example 2-4

If the condition met then, it will return the TRUE

 True Function Example 2-5

else will return False as a result

 True Function Example 2-6

Example #3

We can use a TRUE function with various logical conditions.

Example 3

Example #4

Now we will see the use of the TRUE function used as a BOOLEAN function:

Example 4-1

The output will be:

Example 4-2 

Example #5

Now we will see the use of a TRUE function in other conditions:

Example 5

In the above example, If the condition is met and returns TRUE, then the expression will return the second argument as output, i.e. “PASS”.

Example 5-1

If the condition doesn’t meet the criteria and returns False, then the output will be the third argument which is “FAIL”.

True Function Example 5-2

Example #6

Let’s take a company employee sales target and predefined criteria:

Example 6-1

Example 6-2

Now we have to calculate the commission of sales employees based on the target achieved by them. Here we will use the IF function.

Like below =IF(B59>$A$54,$B$54,$B$53),

Example 6-3

if condition returns TRUE, the employee will get 20% commission.

True Function Example 6-4

If the condition is False then they will get a 10% commission.

Example 6-5

Please check the below results:

Example 6-6

Things to Remember

  • TRUE function without parentheses gives the same result as TRUE().
  • A mostly TRUE function [is used with other functions. In the mathematical calculation, always TRUE is equal to 1, and False is equal to 0.
  • Sometimes when we apply calculations on TRUE and False, then the result will be like this:

TRUE + FALSE = 1

TRUE + TRUE = 2

  • If we want to get the result as TRUE, we directly use the TRUE formula, and Excel will return the logical value TRUE as output.

For Example: IF(23>0, TRUE()) , IF(45<100, TRUE)

  • Logical expressions automatically return Boolean values TRUE or False as output.
  • We also can do numerical calculations with TRUE and False functions like:

TRUE() * 8 = 8

FALSE()* 10 = 0

  • The TRUE function helps us understand whether a given condition is true.

Recommended Articles

This has been a guide to TRUE Function. Here we discuss the TRUE Formula and how to use TRUE Function along with practical examples and downloadable Excel templates. You can also go through our other suggested articles –

  1. NOT in Excel
  2. AND Function in Excel
  3. FALSE Function in Excel
  4. VBA AND

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download TRUE function Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download TRUE function Excel Template

EDUCBA

डाउनलोड TRUE function Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW