Filter by Categories
Select all
Business Statements
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Invoice/ Bill
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
Filter by File Types

Excel Logical Functions : OR

How to use OR Function in MS Excel

Introduction to OR Function

Logical functions in Excel are predefined formulas that evaluate a given condition or set of conditions and return a Boolean value (TRUE or FALSE) based on whether the condition is met or not. They are used to test the truth or falsehood of a statement or a condition, and to make decisions based on the result. In this blogpost, we will discuss about OR Function in Microsoft Excel.

OR Function returns a Boolean value (TRUE or FALSE) after testing conditions you specify. In simple words, you can test multiple conditions with AND function and it returns TRUE if any of those (or all) conditions is TRUE and returns FALSE only if all those conditions are FALSE.

Download Sample File

Download SAMPLE FILE to work, practice and master the LOGICAL Functions in Excel.

Syntax of OR Function

OR(logical1, [logical2], …)

Arguments of OR Function

  • logical1: Condition which you want to verify.
  • [logical2]: Additional Conditions you want to verify.


  • Values will be ignored if the reference cell or array contained an empty cell or text.
  • The result of conditions should be in logical value (TRUE or FALSE).
  • It will return an error if there is no logical value is returned.

Example of OR Function in MS Excel

In the below example, we have created a condition using IF function that if a student score 60 above marks in one of the both of the subjects the formula returns TRUE.

Now in the below example, we have used a number to get logical values in a formula. You can also perform the above condition in reverse order. You can use TRUE and FALSE instead of numbers. OR function treats these logical values as numbers.

Other Excel Logical Functions Tutorials

You can explore and master other Logical functions in Microsoft Excel. Here is a complete list of Logical functions available in Microsoft Excel.


Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes