1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Nested OR and IF Function Tutorial

Combining the OR Function with the IF Function in Excel

By

Using the Excel OR Function

Using the Excel OR Function

© Ted French

Note: These instructions will work for all versions of Excel from Excel 95 to Excel 2013.

Related Tutorial: The Excel OR Function.

The OR function is one of Excel's Logical Functions. Like most logical functions, the output from the OR function is either the word TRUE or FALSE.


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

Example OR Function

Note: This example is typed in cell C1. See the image above for help on this example.

=OR (B1>100, B2>100, B3>100)

If any of these three cells (B1,B2, or B3) contains a value greater than 100, the output for the OR function in cell C1 will be TRUE. If all three cells have numbers less than or equal to 100, the output for the OR function will be FALSE.

Combining the OR Function with the IF Function in Excel

By itself, the OR function has limited usefulness. By combining it with another function, such as the IF function, the OR function can increase the capabilities of your spreadsheet.

Example – Nesting an OR function inside an IF function

=IF(OR(B1>100,B2>100,B3>100),”Over Budget”,”Acceptable”)

Assuming this function is located in cell C1, if any of these three cells (B1,B2, or B3) contains a value greater than 100, the IF function will show the statement Over Budget in cell C1. If all three cells have numbers less than or equal to 100, the IF function shows the statement Acceptable in cell C1.

Note: In Excel 2007, the OR function can contain a maximum of 255 expressions. For earlier versions of Excel, the limit is 30 expressions.

Related Tutorials

©2014 About.com. All rights reserved.