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

Lookup and Reference Examples

  • How to get last row in mixed data with blanks in Excel
  • How to use Excel LOOKUP Function
  • Vlookup Examples in Excel
  • How to retrieve first match between two ranges in Excel
  • How to use Excel ROWS Function

Data Analysis Examples

  • Conditional Formatting New Rule with Formulas in Excel
  • How to create Gauge Chart in Excel
  • Chart Axes in Excel
  • Data Series in Excel
  • Example of COUNTIFS with variable table column in Excel

Data Validation Examples

  • Excel Data validation no punctuation
  • Excel Data validation must not contain
  • Excel Data validation specific characters only
  • Prevent invalid data entering in specific cells
  • Data validation must not exist in list

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 run a test, then take one action if the result is TRUE, and (optionally) do something else if the result of the test is FALSE.

If color is red or green, mark with “x”

In the example shown, we simply want to “mark” or “flag” records where the color is either red OR green. In other words, we want to check cells in column B, and then take action when they contain the word “red” or the word “green”.

Worked Example:   nth smallest value with criteria in Excel

In D6, the formula were using is this:

=IF(OR(B6="red",B6="green"),"x","")

In this formula, the logical test is this bit:

OR(B6="red",B6="green")

This snippet will return TRUE if the value in B6 is either “red” OR “green” and FALSE if not.

Since we want to flag both red and green items, we need to take an action when the result of the test is TRUE. In this case, we do that by adding an “x” to column D. If the test is FALSE,  we simply add an empty string (“”). This causes an “x” to appear in column D when the value in column B is either “red” or “green” and nothing to appear if not.

Worked Example:   How to calculate next scheduled event in Excel

Note: if we didn’t add the empty string when FALSE, the formula would actually display FALSE whenever the color is not red.

Increase price if color is red or green

If you need to do something more complex, just extend the formula.

Worked Example:   Highlight numbers that include symbols in Excel

For example, say you want to increase the price of red and green items only by 15%. In that case, you could use this formula in column E to calculate a new price:

=IF(OR(B6="red",B6="green"),C6*1.15,C6)

The test is the same as before, the action to take if TRUE is new.

If the result is TRUE, we multiply the original price by 1.15 (to increase by 15%). If the result of the test is FALSE, we simply output the original price.

Post navigation

Previous Post:

If cell is not blank in Excel

Next Post:

If cell is x or y and z in Excel

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
  • Convert Text to Numbers in Excel
  • Remove text by matching in a cell in Excel
  • How to extract word containing specific text in Excel
  • DOLLAR function: Description, Usage, Syntax, Examples and Explanation
  • Remove text by position in a cell in Excel
  • How to get same date next month or previous month in Excel
  • Steps to create Dynamic calendar grid in Excel
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • Display the current date and time in Excel
  • Convert text date dd/mm/yy to mm/dd/yy in Excel
  • TBILLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • PDURATION function: Description, Usage, Syntax, Examples and Explanation
  • SYD function: Description, Usage, Syntax, Examples and Explanation
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
  • VDB function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles