Excel OR Function

This tutorial explains how to use the Excel OR function.

Description

The OR function is a logical function that you can use to determine if any of the conditions in a test are TRUE.

Use the Excel AND function if you want to determine if all of the conditions are TRUE.

Syntax
=OR(logical1, [logical2], …)
Argument

  • logical1: The first logical value to evaluate.
  • logical2:  [Optional].The additional logical value to evaluate.

Example:     =OR(1=1, 2=4, 3=5, 2=2)

You can specify up to 255 additional arguments.

Example

Here is our sample data.

A B
1  120 210
2  200 203
3  101 279

Example 1:

=OR(A1<=120, B1>200)

In Example 1 above, OR outputs TRUE if A1 is less than or equal to 120 or B1 is greater than 200, otherwise it outputs FALSE. The result if TRUE.

Example 2:

=OR(A2<100, A2>205)

In Example 2 above, OR outputs TRUE if A2 is less than 100 or A2 is greater than 205, otherwise, FALSE. The result is FALSE.

Example 3:

=OR(A3>110, B2>300)

In Example 3 above, OR outputs TRUE if A3 is greater than 110 or B2 is greater than 300 otherwise FALSE. The result is FALSE.

In this tutorial, you learned how to use the Excel OR function. We use Excel OR function to determine if any conditions in a test are TRUE.

Here is a full list of Microsoft Excel functions.