Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Error Bars in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • Get column index in Excel Table
  • Remove Duplicates Example in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel

References

  • Count unique text values with criteria
  • Basic INDEX MATCH approximate in Excel
  • How to use Excel MATCH Function
  • Perform case-sensitive Lookup in Excel
  • How to get last row in numeric data in Excel

Data Validations

  • Data validation must not exist in list
  • Excel Data validation don’t exceed total
  • Excel Data validation number multiple 100
  • Excel Data validation must not contain
  • Excel Data validation specific characters only

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.

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.

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.

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:

VLOOKUP without #N/A error in Excel

Next Post:

Manipulating text strings using Left, Mid, Right, Len, Substitute 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

Logical Functions

  • Not Equal To ‘<>‘ operator in Excel
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • NOT function: Description, Usage, Syntax, Examples and Explanation
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • IF with boolean logic in Excel

Date Time

  • Count holidays between two dates in Excel
  • Next biweekly payday from date in Excel
  • How to calculate next scheduled event in Excel
  • Convert decimal minutes to Excel time
  • Calculate series of dates by workdays in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • Group times into unequal buckets in Excel
  • Running count group by n size in Excel
  • Map text to numbers in Excel
  • How to randomly assign people to groups in Excel

General

  • Convert column letter to number in Excel
  • How to choose page/paper size in Excel before Printing
  • 231 Keyboard Shortcut Keys In Excel
  • How to calculate percent change in Excel
  • Basic numeric sort formula in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning