Contact
12 programs
Explore the site

OR Function (LibreOffice Calc)

Logical Beginner LibreOffice Calc Introduction not established

The OR function in LibreOffice Calc evaluates multiple logical conditions and returns TRUE when at least one condition is TRUE. Learn syntax, examples, common errors, and best practices.

Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked

Availability and version history

  • Introduced: Documented by LibreOffice 26.8.1.1; original introduction not established.
  • Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
  • Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
  • Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
The **OR** function is a core logical operator in LibreOffice Calc. It evaluates multiple conditions and returns TRUE when *any* condition is TRUE. When combined with `IF`, `AND`, and comparison operators, `OR` becomes essential for flexible decision-making, eligibility checks, and multi-path logic.

What the OR Function Does

  • Evaluates two or more logical conditions
  • Returns TRUE when at least one condition is TRUE
  • Returns FALSE only when all conditions are FALSE
  • Works with numbers, text, dates, and formulas
  • Integrates seamlessly with IF for conditional branching
  • Supports up to 255 logical arguments

It is ideal for eligibility rules, fallback logic, multi‑criteria checks, and flexible decision flows.

Syntax

OR(condition1; condition2; ...)
LibreOffice Calc uses semicolons (;) to separate arguments.

Arguments

  • condition1, condition2, …
    Logical expressions that evaluate to TRUE or FALSE.
    Examples:
    • A1 > 10
    • B2 = "Yes"
    • C3 <= D3

Basic Examples

TRUE when at least one condition is met

=OR(A1 > 0; B1 > 0)

Returns TRUE if either A1 or B1 is greater than zero.

Check if a value is outside a range

=OR(A1 < 10; A1 > 20)

Returns TRUE when A1 is less than 10 or greater than 20.

Check text and numeric conditions together

=OR(B1 = "Active"; C1 > 100)

Returns TRUE when B1 contains “Active” or C1 is greater than 100.

Advanced Examples

OR inside IF (common pattern)

=IF(OR(A1 = "Gold"; A1 = "Platinum"); "Priority"; "Standard")

Returns “Priority” for Gold or Platinum members.

Validate if any required field is missing

=OR(A1 = ""; B1 = ""; C1 = "")

Returns TRUE when at least one cell is empty.

OR with AND for complex logic

=OR(AND(A1 > 0; B1 > 0); C1 = "Override")

TRUE when both A1 and B1 are positive or C1 contains “Override”.

OR with calculations

=OR(SUM(A1:A5) > 100; AVERAGE(B1:B5) < 50)

Evaluates aggregated values rather than individual cells.

OR with text matching

=OR(LEFT(A1; 1) = "A"; LEFT(A1; 1) = "B")

TRUE when A1 begins with A or B.

Common Errors and Fixes

OR always returns TRUE

Possible causes:

  • One condition is always TRUE
  • A text comparison is too broad
  • A number is stored as text

Fix:
Convert text to numbers using:
Data → Text to Columns → OK

OR always returns FALSE

Often caused by:

  • All conditions evaluating to FALSE
  • Incorrect comparison operators
  • Hidden spaces in text values

Err:508 — Missing parenthesis

Occurs when:

  • A nested OR inside IF is missing a closing )
  • Commas are used instead of semicolons

Err:509 — Missing operator

Occurs when:

  • A comparison operator is missing
  • A condition is incomplete (e.g., A1 >)

Best Practices

  • Use OR when any condition should trigger TRUE
  • Combine OR with AND for structured logic
  • Use OR inside IF for multi-path decision-making
  • Avoid overly complex nested logic; use helper cells
  • Ensure consistent data types (numbers vs text)
When building flexible rules, OR is ideal for fallback logic, alternate conditions, and multi‑criteria eligibility checks.
  • Use AND when all conditions must be TRUE
  • Use NOT to invert a logical test
  • Use XOR when exactly one condition must be TRUE
  • Combine OR with COUNTIF, SUMIF, or VLOOKUP for advanced decision workflows

By mastering OR and its combinations with other logical functions, you can build powerful, flexible logic structures in LibreOffice Calc that adapt cleanly to real‑world data.

Reproducible example (tested in LibreOffice Calc)

This standalone example was calculated in LibreOffice Calc 25.2.3.2 and matched the expected value. It is a practical cross-check of one usage, not proof that every example elsewhere on this page is correct.

=OR(TRUE();FALSE())

Expected result: TRUE.

Check whether at least one condition is true.

If the result differs, check the referenced cells, argument separators and number formatting. For more information, consult the LibreOffice Calc official help.