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

Data Analysis

  • Error Bars in Excel
  • Remove Duplicates Example in Excel
  • Filter Data Based on Date in Excel
  • Chart Axes in Excel
  • Conditional Formatting Color Scales Examples in Excel

References

  • How to get address of named range in Excel
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Convert text string to valid reference in Excel using Indirect function
  • Left Lookup in Excel
  • How to retrieve first match between two ranges in Excel

Data Validations

  • Excel Data validation exists in list
  • Excel Data validation date in specific year
  • Excel Data validation number multiple 100
  • Excel Data validation only dates between
  • Excel Data validation must not contain

Tag: OR function

OR function: Description, Usage, Syntax, Examples and Explanation

by

What is OR function in Excel? OR function is one of the Logical functions in Microsoft Excel that determines if any conditions in a test are TRUE. Illustration of OR function Example Here are some general examples of using OR by itself, and in conjunction with IF. Formula Description =OR(A2>1,A2<100) Displays TRUE if A2 is greater than 1 OR less than 100, otherwise …

Continue Reading

If NOT this or that in Excel

by

This tutorial shows how to calculate If NOT this or that in Excel using the example below; Formula =IF(NOT(OR(A1=”red”,A1=”green”)),”x”,””) Explanation If you want to do something specific when a cell is NOT this or that (i.e. is NOT equal to X or Y, etc.) you can use the IF function in combination with the NOT and OR functions …

Continue Reading

If cell is this OR that in Excel

by

This tutorial shows how to calculate If cell is this OR that in Excel using the example below; Formula =IF(OR(A1=”this”,A1=”that”),”x”,””) Explanation If you want to do something specific when a cell equals this or that (i.e. is equal to X or Y, etc.) you can use the IF function in combination with the OR function to …

Continue Reading

If cell is x or y and z in Excel

by

This tutorial shows how to calculate If cell is x or y and z in Excel using the example below; Formula =IF(AND(OR(A1=x,A1=y),B1=z),”yes”,”no”) Explanation You can combine logical statements with the OR and AND functions inside the IF function. If color is red or green and quantity is greater than 10 In the example shown, we …

Continue Reading

Highlight approximate match lookup conditional formatting in Excel

by

This tutorial shows how to Highlight approximate match lookup conditional formatting in Excel using the example below; Formula =OR($B5=LOOKUP(width,widths),B$5=LOOKUP(height,heights)) Explanation To highlight rows and columns associated with an approximate match, you can use conditional formatting with a formula based on the LOOKUP function together with with a logical function like OR or AND. In the example …

Continue Reading

Highlight dates that are weekends in Excel

by

This tutorial shows how to Highlight dates that are weekends in Excel  using the example below; Formula =OR(WEEKDAY(A1)=7,WEEKDAY(A1)=1) Explanation If you want to use conditional formatting to highlight dates occur on weekends (i.e. Saturday or Sunday),  you can use a simple formula based on the WEEKDAY function. For example, if you have dates in the …

Continue Reading

Highlight values not between X and Y in Excel

by

This tutorial shows how to Highlight values not between X and Y in Excel using the example below; Formula =OR(A1<lower,A1>upper) Explanation If you want to use conditional formatting to highlight cells that are NOT between two values (a lower and upper limit), you can use a simple formula that returns TRUE when a value meets …

Continue Reading

Highlight row and column intersection exact match in Excel

by

This tutorial shows how to Highlight row and column intersection exact match in Excel using the example below; Formula =OR($A1=row_val,A$1=col_val) Explanation To highlight intersecting row(s) and column(s) with conditional formatting based on exact matching, you can use a simple formula based on mixed references and the OR function. In the example shown, the formula used …

Continue Reading

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 …

Continue Reading

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 or FALSE otherwise (i.e. if ALL of the conditions …

Continue Reading

IF, AND, OR and NOT Functions Examples in Excel

by

Learn how to use Excel’s logical functions such as the IF, AND, OR and NOT function. If The IF function checks whether a condition is met, and returns one value if true and another value if false. 1. For example, take a look at the IF function in cell C2 below. Above Case Study Explanation: if the …

Continue Reading

Excel If, Nested If, And/Or Criteria Examples

by

IF function is one of the most used functions in Excel. This page contains many easy to follow IF examples. Simple If Examples The IF function checks whether a condition is met, and returns one value if true and another value if false. 1a. For example, take a look at the IF function in cell B2 below. …

Continue Reading

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

  • SWITCH function example in Excel
  • Check multiple cells are equal in Excel
  • Return blank if in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • Excel If, Nested If, And/Or Criteria Examples

Date Time

  • Add business days to date in Excel
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • Get first day of previous month in Excel
  • Get last day of month in Excel
  • How to get workdays between dates in Excel

Grouping

  • Running count group by n size in Excel
  • Calculate conditional mode with criteria in Excel
  • Map inputs to arbitrary values in Excel
  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel

General

  • How to calculate project complete percentage in Excel
  • 231 Keyboard Shortcut Keys In Excel
  • How to get random value from list or table in Excel
  • Mark Workbook as Final in Excel
  • 44 Practical Excel IF function Examples
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning