Excel TRUE function is a logical function that returns the boolean value TRUE. It does not need any arguments to operate. The TRUE function is used by various other conditional functions such as IF function so that if the condition is met, then the output returned is TRUE.
Excel TRUE Function
The TRUE function is classified as a “compatibility function”, needed only for compatibility with other spreadsheet applications. There is no need to use the TRUE function if you are creating a spreadsheet in Excel. Note that logical expressions will automatically generate TRUE and FALSE results.
Syntax
=TRUE()
TRUE Function Example
=IF(A1>100,TRUE())
=IF(A1>100,TRUE)
The above both formulae return TRUE if the value in A1 is greater than 100. Both formulas above based on the IF function are functionally equivalent.