IF OR in Excel




In this tutorial, you will learn IF OR function in excel. Remembering that OR can give TRUE or FALSE logic value and its usage is to evaluate more than one criterion for us, then it can be really useful sometimes when it is combined into IF formula. The explanation about this IF OR function in excel combination will be given in detail in the next parts.


Why We Need to Learn About IF OR Function in Excel?


When doing the writing of a formula that gives a result based on the condition evaluation input in it, sometimes we cannot write in standard manner because the input of condition for the evaluation process needs more than one condition and they must be processed simultaneously. To do it, we need the help of another formula so we can get the result that we need.

The example of this situation is when we are checking production machine data to determine the machines that needs maintenance as soon as possible. This is determined from, for example, if the machine has the occurrence of broken down in the last one week. When checking the data one by one to see whether there is a broken down event in the last one week for each of the machines, we can use a spreadsheet to evaluate the condition thoroughly for each machine and mark even if there is only one broken down event that we see from the data to recommend maintenance for the machine correctly.

The problem is it is a little bit hard to write it manually if we have to evaluate more than one daily condition for each of the machines for determining the maintenance status as soon as possible for all of the machines.

To solve the above case, when there is probably a need for a function that can evaluate more than one condition with the specific requirement that even if there is just one true condition then the function shall give a particular value, you can use the unification of IF OR in excel to help you. IF OR function in excel can help in giving the result depending on our requirements based on the evaluation process result of more than one condition. This combination of IF OR in excel is very useful to be learned if you often deal with various kinds of condition evaluation logic in processing your data on the spreadsheet.


What is the Combination of IF OR in Excel?


IF OR in excel is the unification of two formulas to give a result depending on our requirements based on the evaluation of more than one condition with one kind of thing will be given if the final evaluation gives TRUE result and another kind of thing if it is FALSE.

IF OR function in excel is often used when there is a need to evaluate more than one indicator in a data processing to get a particular result depending on your requirements.

General description about the inputs of these formulas is as follows:


=IF(logical_test, value_if_true, value_if_false)


Note:
  • logical_test = the condition to be evaluated
  • value_if_true = the result if it is right
  • value_if_false = the result if it is wrong



=OR(logical1, logical2, …)


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


How to Use the Combination of IF OR Function in Excel?


The following will explain how to write IF OR in excel. IF OR function in excel needs inputs just like each of the formulas when they are used separately: all the conditions that you want to evaluate, the result if the final evaluation gives TRUE, and the result if it gives FALSE.


Use IF OR in Excel

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

    IF OR in Excel - Screenshot of Step 1

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

    IF OR in Excel - Screenshot of Step 2

  3. Type OR (can be with large and small letters) and open bracket sign

    IF OR in Excel - Screenshot of Step 3

  4. Type all condition which wants to be processed separated by comma signs ( , )

    IF OR in Excel - Screenshot of Step 4

  5. Type close bracket sign when all your conditions have been inputted then type a comma sign

    IF OR in Excel - Screenshot of Step 5

  6. Type cell content if one of the conditions is evaluated true then type a comma sign

    IF OR in Excel - Screenshot of Step 6

  7. Type cell content if all of the conditions is evaluated false

    IF OR in Excel - Screenshot of Step 7

  8. Type close bracket sign

    IF OR in Excel - Screenshot of Step 8

  9. Press Enter
  10. The process of IF OR function in excel is done!

    IF OR in Excel - Screenshot of Step 10



Exercise


After you have learned how to use the IF OR function 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 all of the IF OR function in excel exercise questions and sure about the result!

Link to download the IF OR in excel exercise file:
Download here

Questions

Use the combination of IF OR in excel to answer all the questions
  1. A product can be said that it can be sold in region A if it can sell > 40000 in A1, >35000 in A2, or >45000 in A3 when people look at the previous sales numbers data. Check the sales potency of each product for the region and write the checking result by filling “Yes” or “No” in the provided column!
  2. A product can be said that it can be sold in region B if it can sell > 80000 in B1, >82000 in B2, or >90000 in B3 when people look at the previous sales numbers data. Check the sales potency of each product for the region and write the checking result by filling “Yes” or “No” in the provided column!
  3. A product can be sold if it has the sales potency in one of the regions: A or B. Check whether each product can be sold or not by the company by filling “Yes” or “No” in the provided column!

Link to download the IF OR in excel exercise answer:
Download here


Additional Note


OR alternative for the formula combination with IF which can also be used to get condition evaluation results from more than one condition is AND (give TRUE result if all the conditions have TRUE value). The way to use it can be learned in another part of Compute Expert tutorial!



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