The TRUE function returns the TRUE Boolean value.
It can be useful when you want to explicitly indicate that a value is true in complex logical structures.
Syntax
TRUE()
No arguments are allowed for the TRUE function.
Application
Use in Boolean expressions
=IF(TRUE(), “This is true!”, “This is false.”)
In this case, the formula will always return “This is true!”, since the TRUE function always returns TRUE.
Combining with other Boolean functions
=AND(TRUE(), FALSE())
This formula will return FALSE, since one of the logical operations returns FALSE.
Using as a condition in complex formulas
=COUNTIF(A1:A10, TRUE())
This formula will count the number of cells in the range A1:A10 that contain the logical value (TRUE / 1).
Notes
In most cases, the TRUE function is used for clarity in logical expressions and statements, but you can simply use 1 instead of TRUE().