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

Lookup and Reference Examples

  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel MMULT Function
  • How to use Excel TRANSPOSE Function
  • MATCH function: Description, Usage, Syntax, Examples and Explanation

Data Analysis Examples

  • How to Create One and Two Variable Data Tables in Excel
  • How to create a Histogram in Excel
  • How to Create Area Chart in Excel
  • Remove Duplicates Example in Excel
  • Conditional Formatting Rules in Excel

Data Validation Examples

  • Excel Data validation allow uppercase only
  • Excel Data validation number multiple 100
  • Prevent invalid data entering in specific cells
  • Excel Data validation must not contain
  • Excel Data validation must contain specific text

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

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

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 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 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

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 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

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

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

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

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

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

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
  • How to count specific characters in a range in Excel
  • How to create email address with name and domain in Excel
  • Remove text by position in a cell in Excel
  • LOWER function: Description, Usage, Syntax, Examples and Explanation
  • How to Separate Text Strings in Excel
  • Pad week numbers with zeros in Excel
  • Count day of week between dates in Excel
  • Basic timesheet formula with breaks in Excel
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • Get days between dates ignoring years in Excel
  • How to calculate annuity for interest rate in excel
  • NPV function: Description, Usage, Syntax, Examples and Explanation
  • Calculate payment periods for loan in Excel
  • RRI function: Description, Usage, Syntax, Examples and Explanation
  • How to set check register balance in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles