Introduction

Excel logical functions practice is a core skill for anyone working with spreadsheets. Functions like AND and OR allow you to build more complex logical conditions, making your data models smarter and more reliable. In this guide, we’ll explain how AND & OR work, show step-by-step examples, and give you 20 real-world practice problems to sharpen your Excel logical functions practice.

These logical functions are essential Excel validation skills, helping you build more complex formulas for models, reports, and decision-making. With some practice, you can create powerful conditions that automate data checks and business logic.

Download Excel_Validation_Skills_Practice_AND_OR.xlsx

Excel Logical Functions Practice with AND & OR

  • AND(condition1, condition2, …) → Returns TRUE if all conditions are TRUE.
  • OR(condition1, condition2, …) → Returns TRUE if at least one condition is TRUE.

How to Use:

  1. Click on the cell where you want the result.
  2. Type =AND(condition1, condition2) or =OR(condition1, condition2).
  3. Press Enter to see TRUE or FALSE.
  4. Use these inside IF formulas or Conditional Formatting to automate logic checks.

Practice Dataset

ProductSalesRegionDiscount Eligible?
A120EastYes
B90WestNo
C200EastYes
D150NorthNo
E80EastYes

20 Real-World Practice Problems with Answers & Explanations

Basic Excel Logical Functions Practice Problems

  1. Check if Sales > 100
    • Formula: =AND(B2>100)
    • Answer: TRUE for Product A (120), C (200), D (150)
    • Concept: Simple AND with one condition still works; TRUE if condition satisfied.
  2. Test if Region = “East”
    • Formula: =OR(C2="East")
    • Answer: TRUE for Products A, C, E
    • Concept: OR with single condition; returns TRUE if any cell matches condition.
  3. Check if Sales > 100 AND Region = “East”
    • Formula: =AND(B2>100, C2="East")
    • Answer: TRUE for Products A, C
    • Concept: Both conditions must be TRUE to return TRUE.
  4. Check if Sales < 100 OR Region = “West”
    • Formula: =OR(B2<100, C2="West")
    • Answer: TRUE for Products B, E
    • Concept: TRUE if any condition is satisfied.
  5. Highlight products that meet both conditions (Sales > 100 and Region = East)
    • Formula for Conditional Formatting: =AND(B2>100, C2="East")
    • Answer: Products A and C will be highlighted.
    • Concept: AND function can be used in Conditional Formatting for visual validation.

Intermediate Excel Logical Functions Practice Problems

  1. Check if Sales > 100 and < 200
    • Formula: =AND(B2>100, B2<200)
    • Answer: Products A (120), D (150)
    • Concept: AND allows multiple numerical conditions.
  2. Check if Sales < 100 OR Region = North
    • Formula: =OR(B2<100, C2="North")
    • Answer: Products B (90), D (North), E (80)
    • Concept: OR returns TRUE if either condition is TRUE.
  3. Check if Region = East AND Discount Eligible = “Yes”
    • Formula: =AND(C2="East", D2="Yes")
    • Answer: Products A, C, E
    • Concept: Combines text and logical checks.
  4. Return Pass/Fail based on Sales > 150 AND Region = East
    • Formula: =IF(AND(B2>150, C2="East"), "Pass", "Fail")
    • Answer: Product C → Pass, others → Fail
    • Concept: AND inside IF allows dynamic labeling.
  5. Categorize Region as “Main” if East, otherwise “Other”
    • Formula: =IF(OR(C2="West", C2="North"), "Other", "Main")
    • Answer: Products A, C, E → Main; B, D → Other
    • Concept: OR inside IF helps classify based on multiple options.

Advanced Excel Logical Functions Practice Problems

  1. Check if Sales > 100 AND (Region = East OR Region = West)
    • Formula: =AND(B2>100, OR(C2="East", C2="West"))
    • Answer: Products A, C
    • Concept: Combine AND + OR for complex rules.
  2. Flag mid-tier sales (Sales > 100 and < 200, but not East)
    • Formula: =AND(B2>100, B2<200, C2<>"East")
    • Answer: Product D
    • Concept: Use NOT equal (<>) inside AND for exclusion rules.
  3. Mark Review if Sales < 100 OR Region = North
    • Formula: =IF(OR(B2<100, C2="North"), "Review", "OK")
    • Answer: Products B, D, E → Review; A, C → OK
    • Concept: IF + OR labels multiple conditions dynamically.
  4. Nested AND inside OR for discount rules
    • Formula: =OR(AND(B2>150, C2="East"), AND(B2>200, C2="West"))
    • Answer: Product C → TRUE
    • Concept: Multiple ANDs inside OR for alternative rules.
  5. Apply conditional formatting for East region with sales > 150
    • Formula: =AND(C2="East", B2>150)
    • Answer: Product C highlighted
    • Concept: Conditional formatting + AND helps visually validate datasets.

Expert Excel Logical Functions Practice Problems

  1. Apply 10% discount if Sales > 150 AND Region = East
    • Formula: =IF(AND(B2>150, C2="East"), B2*0.9, B2)
    • Answer: Product C → 180, others remain unchanged
    • Concept: AND + IF can calculate conditional values.
  2. Assign category labels based on multiple conditions
    • Formula: =IF(OR(C2="West", C2="North"), "Secondary", "Primary")
    • Answer: A, C, E → Primary; B, D → Secondary
    • Concept: OR + IF for flexible classification.
  3. Check if three conditions hold
    • Formula: =AND(B2>100, C2="East", D2="Yes")
    • Answer: Products A, C, E → TRUE
    • Concept: AND supports multiple conditions, even text + number combination.
  4. Use nested IFs for tiered logic
    • Formula: =IF(AND(B2>200,C2="East"),"High", IF(AND(B2>100,C2="East"),"Medium","Low"))
    • Answer: C → High, A → Medium, others → Low
    • Concept: Nested IF + AND creates multiple tiers.
  5. Mark “Priority” if Sales > 200 OR (Sales > 100 AND Region = East)
    • Formula: =IF(OR(B2>200, AND(B2>100, C2="East")), "Priority", "Normal")
    • Answer: A, C → Priority; others → Normal
    • Concept: Combine AND + OR inside IF to handle complex business rules.
Download Excel_Validation_Skills_Practice_AND_OR.xlsx

What This Template Teaches

This Excel validation skills practice template helps you:

  • Master AND / OR functions for logical conditions.
  • Validate multiple criteria in datasets.
  • Automate decision-making in models and reports.
  • Build confidence in solving real-world Excel problems step by step.

Next Step: Automate It with PivotXL

While AND and OR are powerful for building logical conditions, applying them across large datasets repeatedly can be time-consuming. PivotXL automates validation, reporting, and conditional checks, ensuring your Excel files remain accurate, dynamic, and consistent—without manual work.