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 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:
Excel AND Function. Excel OR Function. Excel NOT Function. Excel IF Function. Excel IFS Function. Excel IFERROR Function. Excel FALSE Function.
