TRUE Function (LibreOffice Calc)

• Returns the logical value TRUE
• Acts as a boolean constant in formulas
• Works with IF, AND, OR, NOT, and XOR
• Helps create readable, explicit logical expressions
• Useful in validation rules and conditional formatting

It is designed to be simple, predictable, and universally compatible.

TRUE()

Return the boolean value TRUE

=TRUE()

Always returns TRUE.

Use TRUE in an IF statement

=IF(A1 > 10; TRUE; FALSE)

Returns TRUE when A1 is greater than 10.

TRUE as a condition in AND

=AND(TRUE; A1 > 0)

Returns TRUE only when A1 is greater than zero.

TRUE as a condition in OR

=OR(TRUE; A1 > 0)

Always returns TRUE because at least one condition is TRUE.

Use TRUE to simplify logic

=IF(A1 = "Active"; TRUE; FALSE)

Equivalent to:

=A1 = "Active"

TRUE with NOT

=NOT(TRUE)

Returns FALSE.

TRUE with XOR

=XOR(TRUE; A1 > 0)

Returns TRUE only when exactly one condition is TRUE.

TRUE in data validation formulas

=AND(A1 <> ""; TRUE)

TRUE acts as a placeholder to keep the formula structure consistent.

TRUE in conditional formatting

=TRUE()

Applies formatting unconditionally.

TRUE is not text

Cells containing "TRUE" (with quotes) are text, not boolean values.

TRUE is case-insensitive

TRUE, True, and true all evaluate to the boolean TRUE.

TRUE cannot be overwritten as a function

Typing TRUE in a cell always produces the boolean value unless formatted as text.

TRUE vs 1

TRUE behaves like 1 in some contexts (e.g., multiplication), but they are not identical:

• TRUE is a boolean
• 1 is a number

Avoid mixing them unless intentional.

• Use TRUE for clarity when writing logical expressions
• Prefer TRUE over numeric equivalents like 1
• Avoid quoting TRUE as text
• Use TRUE in combination with AND, OR, and NOT for readable logic
• Use TRUE() in conditional formatting to apply rules unconditionally

• Use FALSE for the opposite boolean value
• Use NOT(TRUE) to return FALSE
• Use AND and OR to build multi‑condition logic
• Use IF to return TRUE or FALSE based on a condition

By understanding how TRUE works and how it interacts with other logical functions, you can build clean, expressive, and reliable logic structures in LibreOffice Calc.