What is OR function in Excel?
The OR function is one of the Logical functions of Excel.
It checks whether any of the arguments are TRUE, and returns TRUE or FALSE.
This function returns FALSE only if all arguments are FALSE.
We can find this function in the Logical category of the insert function Tab.
How to use OR function in excel
- Click on an empty cell (like F5 )
2. Click on the fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select Logical category
5. Select OR function
6. Then select ok
7. As shown below, if logica1 =1 and logica2=1, because all condition is true, the result is false
8. If you enter in logica1=0 and logica2 =0, because all condition is false, the result is false
9. If you enter in logica1=1 and logica2=0, because all condition is not false, the result is true
10. If you enter in logica1=0 and logica2=1, because all condition is not true, the result is true
Examples of OR function in excel
Python code for OR function
result=False or True
print(result)What is the purpose of OR function?
It checks whether any of the arguments are TRUE, and returns TRUE or FALSE.
What is the Return value of OR function?
How many arguments does OR function have?
Which version of excel supports OR function?
This function is available for all excel versions (2007-2019)
