Returns logical value TRUE

Syntax of Excel True formula:

In words:
=Return TRUE as a value()


TRUE function is mostly used in scenarios where TRUE argument is required as one of the options especially in logical tests.

Examples of Excel True formula

=If(H7>S6,TRUE,”No more”)
This formula is checking if value in cell H7 is greater than the value in cell S6 then return TRUE other it will result in “No more” message)