TRUE function

This article describes the formula syntax and usage of the TRUE function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.


Returns the logical value TRUE.



The TRUE function syntax has no arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.).


You can enter the value TRUE directly into cells and formulas without using this function. The TRUE function is provided primarily for compatibility with other spreadsheet programs.

Applies to:
Excel 2010, Excel Web App, SharePoint Online for enterprises, SharePoint Online for professionals and small businesses