How to Use Excel OR Function (Example + Video)

Excel OR Function (Example + Video)

Excel OR Function

When to use Excel OR Function

Excel OR function can be used when you want to check multiple conditions.

What it Returns

It returns TRUE if any one of the conditions evaluates to TRUE, else it returns a FALSE.

Syntax

=OR(logical1, [logical2],…)

Input Arguments

  • logical1 – the first condition that you want to evaluate for TRUE or FALSE.
  • [logical2] – (Optional) This is the second condition that you want to evaluate for TRUE or FALSE.

Additional Notes

  • OR function can be used with other formulas to be more efficient.
    • For example, in an IF Function, you can test a condition and then specify a value when it’s TRUE and a value when it is FALSE. Using OR function within IF enables users to test multiple conditions at one go.
      • For example, if you have to test whether if A1 is greater than 0 or less than 100, here is how you can do it in an IF function:
        =IF(OR(A1>100,A1<0),”Approve”,”Reject”)
  • The arguments must either evaluate to logical values (TRUE/FALSE), or the arguments must be arrays/references of logical values.
  • Text and empty cells are ignored.
  • If the specified range contains no logical values, the OR function returns #VALUE! error.
  • You can test a maximum of 255 conditions in a single OR function.

Excel OR Function – Examples

Here are five practical examples of using the Excel OR function.

Example 1: Using True/False arguments in the OR function.

Excel Or Function - Example 1

You can use the True/False arguments directly within the Excel OR function. If any of the given arguments is TRUE, the result would be TRUE. If both the arguments are FALSE, it will return FALSE.

Note: Excel OR function can handle TRUE and FALSE within double quotes. For example, if you use =OR(“TRUE”,”FALSE”), it will return TRUE.

Example 2: Using Cell References that contain True/False.

Excel Or Function - Example 2

You can use cell references that contain TRUE/FALSE. If any of the cell references contain TRUE, the result would be TRUE.

Example 3: Using Conditions within Excel OR Function.

Excel Or Function - Example 3

You can test conditions within the OR function. If any of the conditions is TRUE, the result would be TRUE.

Example 4: Using Numbers within Excel OR Function.

Excel Or Function - Example 4

You can use numbers within Excel OR function. While 0 is considered FALSE, any number other than 0 is considered as TRUE (be a positive, negative, or decimal number).

Example 5: Using Excel OR Function with other functions.

You can use Excel OR function along with other Excel functions when you need to test for multiple conditions.

Here is an example of using OR function with IF function.

Excel Or Function - Example 5

In the above example, IF function uses OR function to test multiple conditions. It checks whether A2 is greater than 70 or A3 is greater than 70. If any of the conditions is TRUE, the OR function returns TRUE. The If function then returns the argument when the condition is TRUE (which is Pass in the above example).

Excel OR Function – Video Tutorial

Related Excel Functions:

DOWNLOAD FREE EXCEL EBOOK

51 Excel Tips to Save Time & Increase Productivity

(22,000+ Enthusiasts have Already Downloaded)