TRUE in Excel (Table of Contents)
TRUE Function in Excel
A TRUE function is a logical function which returns the value TRUE. In excel while calculation or applying any condition, we want that output must return a true value. In these scenarios, we use a TRUE function which is the built-in function in Excel. It is a very useful function when you want to return the output as TRUE based on a condition. A TRUE function is the same like Boolean value TRUE. It’s also called a conditional function.
A TRUE function can be used with other logical functions like IF, ERROR etc.
TRUE Formula in Excel
Below is the TRUE Formula:
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 return 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 easy to use. Let us now see how to use a TRUE function with the help of some examples.
TRUE and TRUE() gives the same result and we can use both vice-versa.
Now we will see the use of a TRUE function with IF function. We want to check if the below values are greater than 30.
For this we will use the below condition:
The output will be:
Drag & drop this formula for all values. The result is shown below:
If the condition met then it will return the TRUE
else will return False as result
We can use a TRUE function with various logical conditions.
Now we will see the use of TRUE function used as a BOOLEAN function:
The output will be:
Now we will see the use of a TRUE function in other conditions:
In above example, If condition met and return TRUE then the expression will return the second argument as output i.e. “PASS”.
If the condition doesn’t meet the criteria and return False, then the output will be the third argument which is “FAIL”.
Let’s take a company employee sales target and predefined criteria:
Now we have to calculate the commission of sales employee based on target achieved by them. Here we will use IF function.
Like below =IF(B59>$A$54,$B$54,$B$53),
thus if condition returns TRUE then the employee will get 20% commission.
If condition False then they will get 10% commission.
Please check below results:
Things to remember about the TRUE Function
- A mostly TRUE function is used with other functions.
- TRUE function without parentheses gives the same result as TRUE().
- 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:
TRUE + FALSE = 1
TRUE + TRUE = 2
- If we want to get the result as TRUE, we directly use TRUE formula and excel will return 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
- TRUE function helps us to understand whether a given condition is actually true or not.
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 –