Excel OR Function

HomeExcel FunctionsExcel OR Function (Example + Sample File)

What is EXCEL OR FUNCTION

The Excel OR Function is listed under Microsoft Excel's Logical Functions category. It returns a boolean value (TRUE or FALSE) after testing conditions you specify. In simple words, you can test multiple conditions with AND function and it returns TRUE if any of those (or all) conditions is TRUE and returns FALSE only if all those conditions are FALSE.

How to use it

To learn how to use the OR function in Excel, you need to understand its syntax and arguments: 

Syntax

OR(logical1, [logical2], …)

Arguments

  • logical1: Condition which you want to verify.
  • [logical2]: Additional Conditions you want to verify.

Notes

  • Values will be ignored if the reference cell or array contained an empty cell or text.
  • The result of conditions should be in logical value (TRUE or FALSE).
  • It will return an error if there is no logical value is returned.

Example

To master the OR function we need to try it out in an example and below is one which you can try out:

In the below example, we have created a condition using IF function that if a student score 60 above marks in one of the both of the subjects the formula returns TRUE.

Now in the below example, we have used a number to get logical values in a formula. You can also perform the above condition in reverse order. You can use TRUE and FALSE instead of numbers.

OR function treats these logical values as numbers.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.