The OR function returns TRUE when at least one condition evaluates to TRUE and returns FALSE if all of its arguments evaluate to FALSE.
Formula:
= OR(logical1, [logical2], …)
Explanation:
– 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.
