OR Function: syntax, examples, mistakes and translation notes
Returns TRUE when any test is true.
Syntax
=OR(logical1, [logical2], ...)
Arguments
logical1
First condition or logical value.
logical2
Optional additional conditions.
Worked examples
=OR(FALSE,TRUE)
Returns TRUE.
=IF(OR(C2="Open",C2="Pending"),"Active","Closed")
Returns Active when either status condition matches.
Practical tips
- Use OR when at least one condition can satisfy the rule.
- Group OR conditions carefully when combined with AND.
- Test each status/criterion separately when unexpected rows match.
Common mistakes
- Using OR when all conditions are required.
- Mixing AND and OR without making the intended grouping clear.
Related functions
Frequently asked questions
What does OR do?
Returns TRUE when any test is true.
Why might a OR formula return an unexpected result?
Using OR when all conditions are required. Start by testing the smallest referenced range or condition independently before adding wrappers or fallbacks.
Check the complete formula
Function syntax is only one part of a working workbook. Paste the finished expression into the Formula Checker for structural warnings, the Formatter for readability or the Translator when a supported locale mapping is involved.
Testing note: examples are educational. Spreadsheet versions, locale settings, tables, named ranges and workbook data can change behavior, so validate important formulas with representative data.