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.
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.
- Enter the following data into cells B1 to B3: 78 , 110 , 45.
- Click on cell C1 - the location where the results will be displayed.
- Click on the Formulas tab.
- Choose Logical Functions from the ribbon to open the function drop down list.
- Click on OR in the list to bring up that function's dialog box.
- Click on cell B1 in the spreadsheet to enter the first cell reference in the logical1 box.
- Type > 100 after the cell reference in the logical1 box.
- Click in the box next to logical2 in the dialog box.
- Click on cell B2 in the spreadsheet to enter the second cell reference.
- Type > 100 after the cell reference in the logical2 box.
- Click in the box next to logical3 in the dialog box.
- Click on cell B3 in the spreadsheet to enter the third cell reference.
- Type > 100 after the cell reference in the logical3 box.
- Click OK.
- The value TRUE should appear in cell C1 because the data in cell B2 is greater than 100.
- The complete function = OR ( B1 > 100 , B2 > 100 , B3 > 100) appears in the formula bar above the worksheet when you click on cell C1.
- To return a value of FALSE in cell C1, type a number in cell B2 that is less than 100.