OR Function in Excel


Home >> How to Use Excel Tutorial >> Excel Formulas List >> OR Function in Excel



In this tutorial, you will learn OR formula in excel. OR function in excel is useful to give final evaluation result to more than one condition that you give as inputs in this OR formula in excel. This formula will give TRUE result if one or more of the condition input has TRUE value.


Why We Need to Learn About OR Formula in Excel?


As a part of the data analysis process that we do in a spreadsheet, sometimes we want to do an evaluation process based on the content of a cell or other indicators. In doing the evaluation process according to the needs of our analysis, often the evaluation from two or more conditions is needed and that kind of thing is a little hard to do if it is done by standard writing.

As an example, imagine if we need to assess performance from all sales in the company’s team based on the detailed data of their product sales results in a spreadsheet. The indicator of whether the performance of the sales is good or bad is if he/she can sell various kinds of company’s product more than the minimum target threshold that has been established by the sales leader of the company. One of the product sales which does not meet the target will give bad status for the assessment result of the salesperson.

Because there are more than one product variations and each of them has its own minimum target threshold, then it will be necessary to use the evaluation process of more than one condition to accommodate the needs of the assessment process. But that cannot be written manually easily and we need the help of a formula to give final evaluation result to more than one condition of ours.

OR function in excel is the formula that can be used to answer the needs. OR formula in excel can help in the case like above where you need correct result or TRUE if one of the conditions has TRUE value. OR function in excel is very useful to be learned and understood for all people who often deal with data in a spreadsheet because you can be certain to face the time when there is a need for condition evaluation in one of the data process that you do.


What is OR Function in Excel?


OR function in excel is a function with the usage objective to give final evaluation result to more than one condition or criteria that you have and this OR formula in excel will give TRUE if one of the conditions has TRUE value too. If all of them are wrong or FALSE, just then it will give a FALSE result.

Most often, OR function in excel is used as a helper in the writing of IF formula condition when there is a need to evaluate more than one condition for the IF criteria.

The following will explain a little bit about the inputs in this formula:


=OR(logical1, logical2, …)


Note:
logical1, logical2, … = all the conditions that you want to evaluate and determine the combined logical value result


How to Use OR Formula in Excel?


The following will explain how to write OR function in excel. OR formula in excel needs the input of all conditions that you want to evaluate with this formula.


Using OR Function in Excel

  1. Type equal sign ( = ) in the cell where you want to put the result in

    OR Function in Excel - Screenshot of Step 1

  2. Type OR (can be with large and small letters) and open bracket sign after =

    OR Function in Excel - Screenshot of Step 2

  3. Type the condition that you want to evaluate

    OR Function in Excel - Screenshot of Step 3

  4. Keep on inputting comma signs ( , ) and repeat step 3 for the other condition that you want to input

    OR Function in Excel - Screenshot of Step 4

  5. Type close bracket sign when all of them have been inputted

    OR Function in Excel - Screenshot of Step 5

  6. Press Enter
  7. The process is done!

    OR Function in Excel - Screenshot of Step 7



Exercise


After you have learned how to use the OR formula in excel above, you can practice your understanding by doing the exercise below!

Download the file from the following link and answer the questions below. Please download the answer if you have done answering the questions and sure about the result!

Link to download the exercise file:
Download here

Questions

In a school where the scholarship passing system is very tight…
  1. A student will pass test group 1 if he/she gets the score more than or equal 90 in one of the group’s tests. Check whether each student passes test group 1 or not and write the result in the provided column! Use TRUE or FALSE as the content of each column cell to give the answer!
  2. A student will pass test group 2 if he/she gets the score more than or equal 95 in one of the group’s tests. Check whether each student passes test group 2 or not and write the result in the provided column! Use TRUE or FALSE as the content of each column cell to give the answer!
  3. A student will get a scholarship if he/she pass one of the test group. Check whether each student gets the scholarship or not and write the result on the provided column! Use “Scholarship” or “No Scholarship” as the content of each column cell to give the answer (use IF combined with OR to answer this question)!

Link to download answer:
Download here


Additional Notes


OR formula in excel alternatives which are related also with condition evaluation result are AND (give TRUE result if all the condition have TRUE value) and NOT (give opposite evaluation result: TRUE becomes FALSE and FALSE becomes TRUE).



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert