The OR function returns TRUE when at least one condition evaluates to TRUE and returns FALSE if all of its arguments evaluate to FALSE.
= OR(logical1, [logical2], …)
- Logical1 is required, the argument that can be evaluated to TRUE or FALSE.
- Logical2 is optional, the argument that can be evaluated to TRUE or FALSE.
In Cell C2, the OR function checks argument A2>1 or A3<10, since A3 = 5, which is less than 10, so the function returns true.
In Cell C3, the OR function checks argument A2<1 or A3>10, values in A2 and A3 cannot meet, so the function returns false.