1. Computing

Excel OR Function

Using the OR Function in Excel

By

Using the Excel OR Function

Excel OR Function

© Ted French

Related Tutorial: Combining the OR Function with the IF Function in Excel.

The OR function is one of Excel’s Logical functions. Like other logical functions, the OR function gives only a TRUE or FALSE answer.

To determine whether the output will be TRUE or FALSE, the OR function evaluates at least one mathematical expression located in another cell in the spreadsheet.

The syntax for the OR function is:

= OR ( logical-1 , logical-2 , ... logical-255 )

logical - refers to the cell reference that is being checked. Up to 255 logical values can be entered into the function.

Example Using Excel's OR Function:

For help with this example, see the image above.

  1. Enter the following data into cells B1 to B3: 78 , 110 , 45.

  2. Click on cell C1 - the location where the results will be displayed.

  3. Click on the Formulas tab.

  4. Choose Logical Functions from the ribbon to open the function drop down list.

  5. Click on OR in the list to bring up that function's dialog box.

  6. Click on cell B1 in the spreadsheet to enter the first cell reference in the logical1 box.

  7. Type > 100 after the cell reference in the logical1 box.

  8. Click in the box next to logical2 in the dialog box.

  9. Click on cell B2 in the spreadsheet to enter the second cell reference.

  10. Type > 100 after the cell reference in the logical2 box.

  11. Click in the box next to logical3 in the dialog box.

  12. Click on cell B3 in the spreadsheet to enter the third cell reference.

  13. Type > 100 after the cell reference in the logical3 box.

  14. Click OK.

  15. The value TRUE should appear in cell C1 because the data in cell B2 is greater than 100.

  16. The complete function = OR ( B1 > 100 , B2 > 100 , B3 > 100) appears in the formula bar above the worksheet when you click on cell C1.

  17. To return a value of FALSE in cell C1, type a number in cell B2 that is less than 100.

Related Tutorials

©2014 About.com. All rights reserved.