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

Data Analysis

  • How To Remove Duplicates In Excel Column Or Row?
  • How to Create One and Two Variable Data Tables in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • How to create Gauge Chart in Excel
  • How to create a Histogram in Excel

References

  • Extract all partial matches in Excel
  • How to get last row in text data in Excel
  • How to use Excel FORMULATEXT function
  • Extract data with helper column in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions

Data Validations

  • Excel Data validation specific characters only
  • Excel Data validation don’t exceed total
  • Excel Data validation only dates between
  • Excel Data validation must begin with
  • Excel Data validation date in specific year

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:   Find most frequent text within a range with criteria 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:   WEEKDAY function: Description, Usage, Syntax, Examples and Explanation

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:   Excel Data validation with conditional list

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:

Complete List of Excel Cube Functions References and Examples

Next Post:

Excel Bar Chart

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

  • AND function: Description, Usage, Syntax, Examples and Explanation
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel FALSE Function
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • Not Equal To ‘<>‘ operator in Excel

Date Time

  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate Day of the Year in Excel
  • How to join date and text together in Excel
  • How to get year from date in Excel
  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • How to randomly assign data to groups in Excel
  • Group numbers with VLOOKUP in Excel
  • Group numbers at uneven intervals in Excel
  • Group times into 3 hour buckets in Excel
  • How to randomly assign people to groups in Excel

General

  • How to get Excel workbook path only
  • How to calculate total from percentage in Excel
  • How to make excel worksheets print on one page?
  • How to create dynamic worksheet reference in Excel
  • How to calculate percent of students absent in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning