Quick, clean, and to the point

Excel TRUE Function

Excel TRUE function

The Excel TRUE function returns the value TRUE. TRUE is classified as a compatibility function, and not needed in most cases. It is equivalent to using the Boolean value TRUE directly in a formula.

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 standard situations.

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.

If you want to test a condition and return different results based on whether the results are TRUE or FALSE, see the examples on this page.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.