Excel Functions Tutorials
- Excel Formulas Cheatsheet
- Financial Functions in Excel
- Logical Functions in Excel
- TEXT Functions in Excel
- Lookup Reference in Excel
- Address Function in Excel
- Choose Function in Excel
- Column Function in Excel
- Columns Function in Excel
- REPLACE Function in Excel
- GetPivotData in Excel
- HLOOKUP in Excel
- Hyperlink Excel Function
- INDIRECT Function in Excel
- LOOKUP Excel Function
- Match Excel Function
- VLOOKUP Excel Function
- INDEX Excel Function
- VLOOKUP vs HLOOKUP
- Maths Functions in Excel
- POWER Function in Excel
- EVEN Function in Excel
- ODD Function in Excel
- ABS Function in Excel
- SUM Function in Excel
- SUMPRODUCT Function in Excel
- SUBTOTAL Excel Function
- ROUND in Excel
- AGGREGATE Excel Function
- PRODUCT Excel Function
- RAND Excel Function
- LOG Excel Function
- EXPONENTIAL Excel Function
- SUMIF in Excel
- TAN Excel Function
- CEILING Excel Function
- LN Excel Function
- SIGN Excel Function
- COS Excel Function
- FLOOR Function in Excel
- SIN Excel Function
- Date and Time Function in Excel
- Statistical Function in Excel
TRUE Excel (Table of Contents)
TRUE Function in Excel
TRUE Excel Function is one of the logical functions in Excel. It returns the logical value of TRUE and is equivalent to the value of TRUE. TRUE function in Excel does not require any argument. It can be used with other logical function such as if, error, etc.
TRUE Excel Formula
There is no parameter or arguments are used in the TRUE Excel Formula.
How to Use TRUE Function in Excel?
TRUE can be used as worksheet function and is very simple and easy to use.
You can understand the working of TRUE function by using the below examples.
TRUE Excel Example #1
Use simple TRUE function in a excel cell.
Output will be TRUE.
TRUE Excel Example #2
Let’s consider another example of TRUE Excel Function. We can use TRUE function with other functions like if here is an example as follows:
Here if condition met with the value then it will return the TRUE as output else it will return False as result.
TRUE Example #3
We can use it to make calculations. For example, we can calculate the following calculations by using TRUE Excel.
Here we use the output of TURE and FALSE function and multiple it with 5 then the result will 5 for TRUE and 0 for False.
TRUE Excel Example #4
In the below example we use the TRUE excel with if function to compare the two column values with each other’s.
It will 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.
TRUE Excel Example #5
TRUE Excel can be used to check the cell value has certain value or not. We can achieve simple cell check by using TURE and if functions details are as follows:
=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.
Things to remember about the TRUE Function in Excel
- TRUE & TRUE() both are unique.
- TRUE() function is basically used with others functions.
- Using TRUE without bracket gives you the same result.
- For calculation purpose TRUE is a 1 and False is a 0 and these can be used for calculation also
- The TRUE function is provided for compatibility with other sheets applications; it may not be needed in standard situations.
- 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 a excel cell or formula and Excel will returns it as the logical value TRUE as output.
For example: =IF (A1<0, TRUE ()), =IF (A1<0, TRUE)
- We also need to remember that logical expressions will also return automatically TRUE and FALSE as results.
- The TRUE function was first used in Microsoft Excel 2007.
You can download this TRUE Function in Excel template here – TRUE Function Excel Template
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