WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » True Excel Function

True Excel Function

By Tanuj KumarTanuj Kumar | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

TRUE Function in Excel

TRUE excel function in excel is a logical function which does not need any arguments in it to operate, as it is a true function the output returned by this function is true, this formula is used by various other conditional functions such as IF function so that if the condition is met the output returned is true or it is returned as false when the conditions do not meet.

Syntax

There is no parameter or arguments are used in the TRUE Excel Formula.

True Function Formula

How to use TRUE Formula in Excel?

You can understand the working of the TRUE function by using the below examples.

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

Example #1

Use the simple TRUE function in an excel cell.

=TRUE()

True Function Example 1

The output will be TRUE.

Example #2

Let’s consider another example of the TRUE Excel Function. We can use a TRUE function with other functions as if. Here is an example as follows:

=IF(B10>20,TRUE())

True Function Example 2

Here if the condition is met with the value, then it will return the TRUE as output else. It will return False as a result. 

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example #3

We can use it to make calculations. For example, we can calculate the following calculations by using TRUE Excel.

True Function Example 3

Here we use the output of TURE and FALSE function and multiply it with 5. Then the result will 5 for TRUE and 0 for False.

Example #4

In the below example, we use the TRUE function with if function in excel to compare the two-column values with each other.

=IF(B28=D28,TRUE())

It would return the TRUE for matched values in column H and J and return FALSE if the value did not match in Column H and J.

Example 4

Example #5

TRUE Excel can be used to check the cell value has a certain value or not. We can achieve a simple cell check by using TURE and if functions details are as follows:

=IF(D53=5,TRUE())

=IF(D55,”Cell has 5″,”Cell does not have  5″)

It will return Cell has 5 as output if cell D53 has 5 and return Cell does not have 5 if the value in D53 does not 5.

Example 5

Things to Remember

  1. TRUE & TRUE() both are unique.
  2. The TRUE() function is basically used with other functions.
  3. Using TRUE without bracket gives you the same result.
  4. For calculation purposes, TRUE is a 1, and False is a 0, and these can be used for calculation also.
    1. TRUE+TRUE=2
    2. FALSE+TRUE=1
  5. The TRUE function is provided for compatibility with other sheets applications; it may not be needed in standard situations.
  6. If we want to enter TRUE, or if we want to provide TRUE as a result in a true excel formula, we can just put the word TRUE directly in an excel cell or formula, and Excel will return it as the logical value TRUE as output.

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

  1. We also need to remember that logical expressions will also return automatically TRUE and FALSE as results.
  2. The TRUE function was first used in Microsoft Excel 2007.

Recommended Articles

This has been a guide to TRUE Function in Excel. Here we discuss the TRUE Excel Formula and how to use TRUE Function in Excel along with practical examples and downloadable excel templates. You may also look at these useful functions in excel

  • VLOOKUP with TRUE
  • Consumption Function Formula
  • Excel Macro
  • Address in Excel
  • Pivot Table Change Data Source
9 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Login

Forgot Password?

WallStreetMojo

Download TRUE Function Excel Template

Coursera IPO Financial Model & Valuation Free Download