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

Lookup and Reference Examples

  • Excel Advanced Lookup using Index and Match Functions
  • How to use Excel MATCH Function
  • Basic INDEX MATCH approximate in Excel
  • How to get address of last cell in range in Excel
  • How to use Excel COLUMN Function

Data Analysis Examples

  • How To Compare Two Lists in Excel
  • How to Sort by Color in Excel
  • How To Filter Data in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How To Remove Duplicates In Excel Column Or Row?

Data Validation Examples

  • Excel Data validation date in next 30 days
  • Excel Data validation whole percentage only
  • Excel Data validation unique values only
  • Excel Data validation no punctuation
  • Excel Data validation date in specific year

How to use Excel OR Function

by

This Excel tutorial explains how to use the  OR function with syntax and examples.

Excel OR Function Description

The Excel OR function tests a number of supplied conditions and  returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE.

That is;

  • TRUE if ANY of the conditions evaluate to TRUE
Worked Example:   OR function Examples in Excel

or

  • FALSE otherwise (i.e. if ALL of the conditions evaluate to FALSE).

Excel Or Function Examples

The following spreadsheet shows three examples of the Excel Or function.

Explanation: Based on the above examples, the OR function returns;

  • the function in cell C1 evaluates to TRUE, as BOTH of the supplied conditions are TRUE;
  • the function in cell C2 evaluates to TRUE, as the first condition, A2>0 evaluates to TRUE;
  • the function in cell C3 evaluates to FALSE, as ALL of the supplied conditions are FALSE.
Worked Example:   Highlight approximate match lookup conditional formatting in Excel

Syntax

The syntax for the OR function

OR( logical_test1, logical_test2, ... logical_testn )

Arguments

logical_test1
A condition to test that can either be TRUE or FALSE.
logical_test1, ... logical_test_n
Optional. Conditions to test that can either be TRUE or FALSE. There can be up to 30 conditions.
Worked Example:   If cell is x or y and z in Excel

Returns

The OR function returns TRUE if any of the conditions are TRUE.
The OR function returns FALSE if all conditions are FALSE.

Post navigation

Previous Post:

How to use Excel AND Function

Next Post:

How to use Excel TRUE Function

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
  • REPT function: Description, Usage, Syntax, Examples and Explanation
  • How to check if cell contains all of many things in Excel
  • Get position of 2nd 3rd and more instance of character in Excel
  • PROPER function: Description, Usage, Syntax, Examples and Explanation
  • Excel MAX, MATCH and ADDRESS function illustration
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate Day of the Year in Excel
  • WEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Generate series of dates by weekends in Excel
  • Add workdays no weekends in Excel
  • MDURATION function: Description, Usage, Syntax, Examples and Explanation
  • YIELDDISC function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate present value of annuity in excel
  • Calculate payment for a loan in Excel
  • PDURATION function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles