In this article, we will learn how to use OR function in Excel.
AND function in Excel runs a basic logical function to test two values or statments. OR function checks if any of the condition in formula is False, returns False and it returns True only if all condition or statements are True.
OR function can be used via many ways.
Let’s understand them one by one
Here we have few Examples to test multiple conditions and statements of AND function.
Use the formula in E2 cell.
It returns True as all the statements return True.
There are some default AND Excel statements
Apply the formula in other cells using Ctrl + D taking the first applied cells till the cell you wish to copy formula.
In the E2 cell, we applied the formula
We test the 4 conditions in this AND formula. All conditions returns 4 which is considered True is Excel.
If all conditions returns positive numbers and any of it returns 0 then the formula will return False.
You can check less than or greater than condition on numbers. OR function can also be used along with many function like IF, AND and many more.
Hope you understood how to use OR function in Excel. Explore more articles on logic_test functions here. Feel free to state your queries in the comment box below.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.