Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.
IF Function is one of the most powerful functions in excel. And, the best part is, you can combine other functions with IF to increase its power.
Combining IF and OR functions is one the most useful formula combination in excel.
In this post, I’ll show you why we need to combine IF and OR functions. And, why it’s highly useful for you.
Table of Content
I am sure you have used both of these functions but let me give you a quick intro.
IF Function – Use this function to test a condition. It will return a specific value if that condition is true, else some other specific value if that condition is false.
OR Function – Test multiple conditions. It will return true if any of those conditions is true, false if all of those conditions are false.
The crux with both of the functions is IF function can test only one condition at a time. And, OR function can test multiple conditions but only return true/false.
And, if we combine these two functions we can test multiple conditions with OR & return a specific value with IF.
In the syntax of IF function, have a logical test argument in which we use to specify a condition to test.
And, then it return a value based on the result of that condition.
Now, if we use OR function for that argument and specify multiple conditions into it.
If any of the conditions is true OR will return true and IF will return the specific value.
And, if none of the conditions is true OR with return false and IF will return another specific value.
In this way, we can test more than one value with IF function.
Let’s get into some real life examples.
Here I have a table with stock details of two warehouses. Now the thing is I want to update status in the table.
If there is no stock in both of the warehouses status should be “Out of Stock”.
And, if there is stock in any of the warehouse status should be “In-Stocks”.
So, here I have to check two different conditions “Warehouse-1” & “Warehouse-2”.
And the formula will be.
=IF(OR(B2>0,C2>0),”In-Stock”,”Out of Stock”)
In above formula, if there is a value greater than zero in any of the cells (B2 & C2) OR function will return true, and IF will return value “In-Stock”.
But, if both cells a has zero then OR will return false and IF will return value “Out of Stock”.
Both of the functions are equally useful but when you combine them, you can use them in a better way
As I told you, by combining IF and Or functions you can test more than one conditions. You can solve you two problems with this combination of functions.
So what do you think?
Do you have any unique idea to use IF and OR Functions?
Share with me in the comment box.