Excel functions

The OR function

Returns TRUE when at least one condition is TRUE.

Syntax

OR(logical1, [logical2], ...)

logical1: The first condition.
logical2 (optional): More conditions, up to 255.

Examples

C1=OR(¹A2<50,²A2>60)

	A	B	C
1	Score		TRUE
2	62

In plain words: TRUE when the score in A2 is below 50 or above 60.

C1=OR(A2<50,A2>90)

	A	B	C
1	Score		FALSE
2	62

Practice OR

1Either condition with OR→

Read the guide

Related functions