The OR function returns TRUE if at least one given condition is met, and FALSE if none of the conditions are satisfied.
This formula will return TRUE if the value in A1 is even and positive.
Syntax
OR(logical_test1, [logical_test2, ...])
Argument |
Description |
Permitted values |
|---|---|---|
logical_test1 |
A Boolean condition or expression, or a reference to a cell containing an expression that evaluates to TRUE or FALSE, or an expression that can be converted to a Boolean value. |
Any Boolean expressions or conditions that return TRUE or FALSE. For example, C2="Income", C2<10 or C2>B2 |
[logical_test2, ...] |
Additional Boolean conditions or expressions, or references to cells containing expressions with Boolean values TRUE or FALSE, or expressions that can be reduced to Boolean values |
Similar to the first argument |
Examples of use
Checking multiple conditions
=OR(A1 > 10, B1 < 5)
This formula will return TRUE if the value in A1 is greater than 10 or the value in B1 is less than 5.
Use in a conditional formula
=IF(OR(A1 < 0, A1 > 100), "Out of range", "Within range")
This formula will check whether the value in cell A1 is out of the range from 0 to 100 and return a corresponding message.
Checking for the presence of a value
=OR(A1 = “Yes”, A1 = “Oui”)
This formula will return TRUE if the value in A1 is “Yes” or “Oui.”
Notes
–The OR function can accept up to 255 logical conditions.
–The function is often used in combination with other functions, such as IF, to create more complex logical expressions.