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:
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.
- This function doesn’t have any arguments.
- It helps to return a logical value TRUE or FALSE.
- 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.
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.
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.
- 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.
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, IF Function.
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.
The following video will show you how to use the Excel TRUE function in the spreadsheet with proper examples.
More Logical Functions for you: