OR Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

OR is an Excel Logic function. Returns TRUE if at least one condition given is true.

OR syntax

Arguments

• logical1: The first condition to check
• logical2: An additional condition to check (optional) (optional)

When to use OR

OR is used to build decision rules directly into a spreadsheet instead of manually judging each row.

OR practice questions

• Write Weekend if the day is Sat or Sun, otherwise Weekday. Put it in C2 to C4.
• Write Out of range if the age is below 18 or above 60, otherwise OK. Put it in C2 to C4.
• Write West if the city is Pune or Mumbai, otherwise Other. Put it in C2 to C4.
• Give a Discount if the customer is a member (Yes) or the amount is above 5000, otherwise…
• Write Fail if any of the three marks is below 35, otherwise Pass. Put it in E2 to E4.
• Write Incomplete if the name or the city is empty, otherwise OK. Put it in C2 to C4.
• A customer is VIP if the level is Gold or Platinum and the spend is 1000 or more,…
• Count how many customers are from Pune or Surat (cities in B2:B6) and put the count in D2.

More Logic functions

• IF
• IFS
• AND
• NOT
• XOR
• IFERROR
• IFNA
• SWITCH
• LAMBDA
• LET
• BYROW
• BYCOL
• MAP
• REDUCE

All Excel formulas · Cheat sheet · Excel exercises · Logic functions · Excel case studies · Excel tutorials · Excel shortcuts