< Go Back

How to Use IF OR Function in Excel

While evaluating a data set you come across to a situation where you need to test multiple conditions or logical tests. Excel IF function allows users to logically compare values by testing condition(s) and returning a value if that condition(s) is TRUE or FALSE.

If you have multiple conditions to logically test and want to return a value where any one of the conditions is TRUE or FALSE then IF OR statement comes into action.

Excel OR function is categorized as logical function and it returns TRUE if any of the given conditions are TRUE, otherwise it returns FALSE.

As a combined IF OR statement, OR function is used as a logical_test argument and if any of the specified conditions are TRUE, OR function returns TRUE and IF statement returns value_if_true argument’s value, otherwise it returns value_if_false argument’s value.  

Here is the syntax of IF OR Statement;

IF(OR( condition1, [condition2], ... ), value_if_true, value_if_false)

Please note when you have entered all the conditions in OR function then you must put closing bracket to complete logical_test argument. After that you need to enter TRUE or FALSE argument as part of the IF statement.

When any of the conditions are TRUE in OR function, then you can perform calculations as per your requirement in TRUE or FALSE arguments of IF OR formula in Excel, such as;

=IF(OR(A2=”A”,B2<=20),C2*1.5,C2*1.2)

In this IF OR formula, it says, if cell A2 value is “A” or cell B2 value is less than equal to 20, then return value after multiplying cell C2 value with 1.50, otherwise return value after multiplying cell C2 value with 1.20. In this way you can perform various calculations if any of the conditions are TRUE/FALSE.   

 

Let’s suppose you have a data set of men’s garments of a store. Each product has different prices for different sizes and colors available in stock. Management has decided to revise prices of products that come in any of the specified colors, irrespective of their sizes, and keep the rest of products’ prices same.  

Using IF OR statement you can specify the colors whose prices are to be revised with certain percentage say by 10% and keep the rest of the products’ prices same as previous. Let say any product that comes in any of colors “Red” and “Orange” the prices of those products to be increased by 10% and keep the rest of products’ prices same.

You need to supply these two conditions in OR function of IF OR formula. OR function will return TRUE, if the product’s color meets any of these colors (Red and Orange), and IF statement will return revised price of that product after multiplying the old price with 1.10 as specified in value_if_true argument, otherwise IF statement will return old price of that product.

IF OR statement for the above example would be as follows;

=IF(OR(C2="Red",C2="Orange"),D2*1.1,D2)

Here you can see that IF OR formula has performed the required calculations where any of the given conditions are TRUE otherwise it has returned the old values of products’ prices.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar