Related Function:

The TRUE function returns the logical value TRUE.

Syntax

=TRUE()

Note: TRUE takes no arguments but requires empty parentheses.

  • You can get the same result by simply typing TRUE directly into a worksheet cell.
  • The TRUE function is provided primarily for compatibility with other spreadsheet programs.

Examples

  A B C
1 1    
2      
3 Formula Result Notes
4 =IF(A1=1,TRUE()) TRUE You can also enter the value TRUE directly into cells and formulas without using this function, as in the formula in A5
5 =IF(A1=1,TRUE) TRUE