Generate the logical value TRUE

Related Functions

Sponsored Link



Generate the logical value TRUE

Return value 

The logical value TRUE


=TRUE ()



Usage notes 

The TRUE function is provided for compatibility with other spreadsheet applications and there is no need to use it in almost all cases.

If you want to enter TRUE, or provide TRUE as a result in a formula, you can just use enter the word TRUE directly into a cell or formula and Excel will interpret this as the logical value TRUE. For example, these formulas are functionally identical:

=IF(A1<0, TRUE())=IF(A1<0, TRUE)

Also note that logical expressions themselves will automatically generate TRUE and FALSE results. For example, the formula in cell C7 is:


This expression evaluates to TRUE, which is the result that appears in the spreadsheet.

Sponsored Link

0 votes. 0 / 5