Excel TRUE Function (Example + Video)
When to use Excel TRUE Function
TRUE function returns the logical value TRUE. It does not take any input arguments.
What it Returns
It returns the logical value TRUE.
Syntax
=TRUE()
Input Arguments
- It does not take any input arguments.
Additional Notes
- TRUE function is best used when you are evaluating a condition, and if is TRUE, you simply want to get the TRUE value in the cell. For example:
- =IF(AND(A1>0,A1<100),TRUE(),”Reject”)
In this example, if the condition is not met, it simply returns TRUE as the result.
- =IF(AND(A1>0,A1<100),TRUE(),”Reject”)
- If you type TRUE (without parenthesis) in a formula or in a cell, excel automatically takes it as the TRUE logical value.
- TRUE and TRUE() both would return the same value.
- In terms of value, a FALSE is a 0 and a TRUE is a 1. These can be used in calculations.
- For example: =TRUE+TRUE would be 2 and =FALSE+TRUE would be 1
- According to Microsoft Help, Excel TRUE function is provided primarily for compatibility with other spreadsheet programs.
Excel TRUE Function – Live Example
Excel TRUE Function – Video Tutorial
Related Excel Functions:
