Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Vlookup Examples in Excel
  • How to create dynamic named range with OFFSET in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Create hyperlink with VLOOKUP in Excel
  • Merge tables with VLOOKUP in Excel

Data Analysis Examples

  • How to Create Gantt Chart in Excel
  • How to create running total in an Excel Table
  • How To Remove Duplicates In Excel Column Or Row?
  • Working With Tables in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel

Data Validation Examples

  • Prevent invalid data entering in specific cells
  • Excel Data validation date in next 30 days
  • Excel Data validation must begin with
  • Excel Data validation allow uppercase only
  • Excel Data validation require unique number

OR function Examples in Excel

by

The OR function in Excel returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false. Combine the OR function with other functions and become an Excel expert.

1. For example, take a look at the OR function in cell D2 below.

Explanation: the OR function returns TRUE if the first score is greater than 70 or the second score is equal to 100, else it returns FALSE.

2. Combine the OR function with the IF function.

Explanation: the OR function returns TRUE or FALSE (see previous example). If TRUE, the IF function returns Pass, if FALSE, the IF function returns Fail.

Worked Example:   IF with wildcards in Excel

3. For example, take a look at the OR function in cell E2 below.

Explanation: the OR function returns TRUE if at least one score is greater than or equal to 90, else it returns FALSE. The OR function can test up to 255 conditions. The only way for the OR function to return FALSE is if all the conditions are FALSE (row 6).

4. The array formula below uses the OR function to return TRUE if any cell in the range A1:E6 is greater than or equal to 90.

Explanation: finish an array formula by pressing CTRL + SHIFT + ENTER. Excel adds the curly braces {}. The value in cell D4 is greater than or equal to 90. As a result, the array formula returns TRUE.

5. Combine the OR function with the AND function.

Worked Example:   Nested IF function example in Excel

Explanation: the AND Function returns TRUE if all conditions are true and returns FALSE if any of the conditions are false. The AND function above has two arguments separated by a comma (Table, Green or Blue). The AND function returns TRUE if Product equals “Table” and Color equals “Green” or “Blue”.

6. Combine the OR function with the WEEKDAY function.

Worked Example:   Get work hours between dates custom schedule in Excel

Explanation: the WEEKDAY function in Excel returns a number from 1 (Sunday) to 7 (Saturday) representing the day of the week of a date. As a result, the OR function returns TRUE if the date falls on a weekend.

7. Don’t confuse the OR function with the XOR (Exclusive OR) function.

Explanation: the XOR function returns TRUE if an odd number of conditions are true, and FALSE otherwise. With two conditions (see example above) the XOR function returns TRUE if one condition is TRUE (row 2) and returns FALSE if both conditions are false (row 3, 4 and 6) or both conditions are true! (row 5).

Post navigation

Previous Post:

How to create Roll the Dice in Excel

Next Post:

Sumproduct Function Example in Excel

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to count total characters in a range in Excel
  • How to extract domain from email address in Excel
  • How to Separate Text Strings in Excel
  • NUMBERVALUE function: Description, Usage, Syntax, Examples and Explanation
  • How to translate letters to numbers in Excel
  • Calculate days remaining in Excel
  • Get work hours between dates custom schedule in Excel
  • Excel Date & Time Functions Example
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • Add days to date in Excel
  • PMT function: Description, Usage, Syntax, Examples and Explanation
  • Calculate loan interest in given year in Excel
  • PRICE function: Description, Usage, Syntax, Examples and Explanation
  • MDURATION function: Description, Usage, Syntax, Examples and Explanation
  • NPER function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles