OR Function in Excel
Beginner
Returns TRUE if any argument is TRUE, FALSE if all arguments are FALSE.
Syntax
=OR(logical1, [logical2], ...)Example
Use Case
Check if a payment was made by credit card OR PayPal.
Common Errors to Avoid
- Returns TRUE if just one condition is TRUE
- Cannot handle array operations without additional functions
- Different from XOR - OR returns TRUE if one or more conditions are TRUE
Pro Tips
Combine with IF for conditional logic: =IF(OR(A1='Red',A1='Blue'),'Primary','Other'). For array operations, use + (addition): (A:A='X')+(B:B='Y') in SUMPRODUCT. Consider using multiple IF statements for complex scenarios.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →