Quick Navigation
OR Function
Summary
The OR function is a powerful logical tool that returns TRUE when at least one condition in a set of tests evaluates to TRUE. It's essential for creating flexible decision-making formulas that test multiple criteria simultaneously.
Syntax
OR(logical1, [logical2], ...)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| logical1 | Logical |
Yes | Required first condition that evaluates to TRUE or FALSE |
| logical2, ... | Logical |
No | Optional additional conditions, up to 255 total arguments |
Using the OR Function
OR expands the power of conditional functions by testing multiple criteria at once. Use it within IF statements to trigger actions when any of several conditions are met, or combine with other logical functions for complex decision trees.
Common OR Examples
Basic Range Check
=OR(A2>100, A2<0)Returns TRUE if value is outside normal range (over 100 or under 0)
Multiple Criteria Alert
=IF(OR(B2="", C2="", D2=""), "Complete all fields", "OK")Warns if any required field is empty
Sales Commission Trigger
=IF(OR(Sales>=Goal1, Accounts>=Goal2), Sales*Commission%, 0)Pays commission if either sales OR account target is met
Array Search
=OR(A1:A10=50)Checks if 50 appears anywhere in range A1:A10 (array formula)
Frequently Asked Questions
Common Errors and Solutions
#VALUE!
Cause: Range contains no logical values
Solution: Ensure arguments evaluate to TRUE/FALSE or use ISERROR checks
Unexpected FALSE results
Cause: All conditions evaluate FALSE or contain ignored text
Solution: Verify each condition separately using individual IF tests
Notes
- Maximum 255 arguments
- Array formulas require Ctrl+Shift+Enter (older Excel)
- Non-logical values convert to FALSE
- Ideal partner for IF and SUMPRODUCT functions
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365
Not available in:
Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+