OR function in Excel

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

  1. Click on an empty cell (like F5 )
empty cell excel

2. Click on the fx icon (or press shift+F3)

 fx icon in excel

3. In the insert function tab you will see all functions

insert function tab in excel

4. Select Logical category

5. Select OR function

6. Then select ok

logical function category in excel

7. As shown below, if logica1 =1 and logica2=1, because all condition is true, the result is false

examples of or function in excel

8. If you enter in logica1=0 and logica2 =0, because all condition is false, the result is false

examples of or function in excel

9. If you enter in logica1=1 and logica2=0, because all condition is not false, the result is true

examples of or function in excel

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

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)

Errors in OR function

OR related functions

Leave a Reply

Your email address will not be published. Required fields are marked *