TRUE

Retrun the logical value TRUE in Excel
Returns the logical value TRUE

Rational

Return the logical value TRUE

Description

The Excel TRUE function returns the logical value ‘TRUE’. The formula is useful to enter the TRUE directly into the cell or added as part of criteria in a formula. TRUE is a compatibility function.

Syntax

= TRUE()

Parameters

[Empty Parenthesis]

Return Value

Logical value TRUE

Key Notes

  • The TRUE function is merely for compatibility purpose with other spreadsheet programs.
  • You can manually enter TRUE in the formula rather than TRUE() function.
  • Logical expressions themselves will automatically generate TRUE and FALSE results.

Keep Reading Similar Functions:

Reverse the logical value of the argument in Excel

NOT

The NOT function reverse a boolean result (TRUE or FALSE) of logical criteria in the argument. For example, =NOT(5=5) return FALSE (opposite the result).

Read More »
Return the logical value FALSE in Excel

FALSE

The FALSE function returns the logical value FALSE. The formula is useful to enter the FALSE directly into the cell or added as part of criteria.

Read More »