How to Use OR Function

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.

Download: OR Function

Leave a Reply