Excel TRUE function

Summary

The Excel TRUE function is used to explicitly return the logical value TRUE. Similar to the FALSE function, TRUE can be used for clarity in formulas, particularly where logical decisions are being made. Logical expressions inherently return either TRUE or FALSE, but explicitly using TRUE can make formulas more readable.
Syntax
				
					=TRUE()
				
			
This function does not take any arguments.
Return value
The logical value TRUE.

How to use

TRUE can be used in any context where a definite TRUE value is needed, especially in logical conditions like IF functions. It serves the same purpose as directly using the TRUE value or allowing a logical expression to evaluate to TRUE.

Examples

TRUE and IF
The TRUE function generates the Boolean value TRUE. Consequently, the two IF function-based formulas presented below achieve the same result:
				
					=IF(A1 <= 10, TRUE())
=IF(A1 <= 10, TRUE)
				
			
These formulas assess if the value in A1 is less than or equal to 10. If true, the two formulas explicitly return TRUE.

Additional Notes

  • Using TRUE() is functionally equivalent to using the logical value TRUE.
  • Logical operations in Excel always result in either TRUE or FALSE.
  • Explicitly using TRUE or TRUE() can enhance the clarity of formulas involving logical decisions.

Related Functions

Excel FALSE function

The Excel FALSE function is a logical function that returns the logical value FALSE, requiring no arguments.

Excel IF function

The Excel IF function checks a condition to return values for TRUE or FALSE outcomes, ideal for dynamic decision-making.

Content Navigation