How it works.
OR evaluates multiple conditions and returns TRUE if at least one condition is met. It returns FALSE only if all conditions are FALSE. It is commonly used inside IF statements to check alternative conditions.
💡 In simple terms.
Checks multiple rules. It outputs TRUE if at least one rule is met; it only outputs FALSE if all rules fail.
Analogy
"Think of this like qualifying for a free drink. You qualify IF you have a coupon OR it is your birthday. You only need one of them to be true!"
Syntax guide.
=OR(logical1, [logical2], ...)
Parameters
logical1Required
The first condition to test.
logical2Optional
Additional conditions to test.
Interactive formula builder.
Fill in the input arguments below to construct your custom formula string. Copy it directly to paste into your Excel spreadsheets.
Generated Output
Best Practices
- Use OR to check if a cell contains one of several options: e.g. `=OR(A2="Red", A2="Green", A2="Blue")`.
Common Gotchas
- If you supply array ranges to OR, they must be formatted correctly, otherwise it can return #VALUE! or slow down calculation.