# Excel TRUE Function | Formula Examples + FREE Video

## 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.

=TRUE()

### Input Arguments

• It does not take any input arguments.

• 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 – Video Tutorial

Related Excel Functions: