How to Use Excel's TRUE Function

By Matt Skaggs

The TRUE function in Excel simply returns the word “TRUE” in a cell, and although it requires parentheses like other functions, it cannot accept any text within its parentheses. It can be typed only as "TRUE()". This function can be used as an independent function in a cell, or it can be a return value, such as for an IF function.

TRUE Function Applications

The only application of the TRUE function is to resolve compatibility issues between Excel and other spreadsheet programs; in all other cases, simply typing the word "TRUE" is sufficient. When nesting the TRUE function in an IF function, you can pair it with the FALSE function, which is identical except that it returns the word “FALSE.”

True Function Examples

An example of using the TRUE function with the IF function is “=IF(B1>100, TRUE(), FALSE())”, which returns “TRUE” only if the number in cell B1 is greater than 100; otherwise it returns "FALSE." When the TRUE function is the only function used in a cell, the Formula Bar should contain “=TRUE()”, and the cell will always return the word “TRUE.”