Excel Function

OR

Returns TRUE when any condition is TRUE.

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

Arguments

logical1

Required

Enter the first condition expression.

logical2

Optional

Enter the second condition expression.

Practice Preview

Use OR to check whether either cell B2 (Score in column B) is greater than or equal to 80 or cell C2 (Attendance Rate in column C) is greater than or equal to 97 is true.

Example Table

#	ALearner ID	BScore	CAttendance Rate
2	U001	82	96
3	U002	67	87
4	U003	91	99
5	U004	55	72
6	U005	78	90
7
8

How to Use (Formula)

=OR(B2>=80, C2>=97)

Result

TRUE

Practice This Function

Start Function Practice Back to Function List

OR FAQ

How do I use OR in Excel?

Use OR when you want to check whether any condition is true. Enter Logical test 1, Logical test 2 in that order, then add optional arguments when needed.

Where can I practice OR?

Use the "Start Function Practice" button to jump straight into OR drills.

What arguments does OR use?

The main arguments are Logical test 1, Logical test 2. Start with the required ones, then add optional arguments if needed.