OR Function (LibreOffice Calc)
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.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✔ |
| Libreoffice | ✔ |
| Numbers | ✔ |
| Onlyoffice | ✔ |
| Openoffice | ✔ |
| Wps | ✔ |
| Zoho | ✔ |
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; ...)
;) to separate arguments.
Arguments
- condition1, condition2, …
Logical expressions that evaluate to TRUE or FALSE.
Examples:A1 > 10B2 = "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)
Related Patterns and Alternatives ▾
- 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.