---
title: "AND and OR practice exercises | PracticeExcel"
description: "Practice AND and OR inside IF in a live spreadsheet."
canonical_url: "https://practiceexcelonline.com/practice/logical"
locale: en
meta:
  "og:description": "Practice AND and OR inside IF in a live spreadsheet."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_AND%2Band%2BOR%2Bpractice%2Bexercises%2Cdescription_Practice%2BAND%2Band%2BOR%2Binside%2BIF%2Bin%2Ba%2Blive%2Bspreadsheet.%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRCJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJTZWxsZXIiLCJEZWFscyIsIlJhdGluZyIsIkJvbnVzPyJdfSx7Im4iOjIsImNlbGxzIjpbIk1pa2tlbCIsIjciLCI0LjYiLCIiXX1dLCJ0YXJnZXQiOlsxLDNdfX0%2Cp_Ii9wcmFjdGljZS9sb2dpY2FsIg%2Cs_ALTYw2nEm53X0Imp.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "AND and OR practice exercises | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_AND%2Band%2BOR%2Bpractice%2Bexercises%2Cdescription_Practice%2BAND%2Band%2BOR%2Binside%2BIF%2Bin%2Ba%2Blive%2Bspreadsheet.%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRCJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJTZWxsZXIiLCJEZWFscyIsIlJhdGluZyIsIkJvbnVzPyJdfSx7Im4iOjIsImNlbGxzIjpbIk1pa2tlbCIsIjciLCI0LjYiLCIiXX1dLCJ0YXJnZXQiOlsxLDNdfX0%2Cp_Ii9wcmFjdGljZS9sb2dpY2FsIg%2Cs_ALTYw2nEm53X0Imp.png"
---

> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)

# **AND and OR practice exercises**

Combine conditions with AND (all must be true) and OR (one is enough), usually inside IF.

[**Start the first exercise**](https://practiceexcelonline.com/practice/logical/if-and)

AND(OR(

1. [**1****Two conditions with AND**A seller gets a bonus only with at least 5 deals AND a rating of at least 4.5. In D2, use IF with AND to show "Yes" or "No".](https://practiceexcelonline.com/practice/logical/if-and)
2. [**2****Either condition with OR****Premium**Shipping is free for Gold customers OR for orders of 500 or more. In D2, use IF with OR to show "Yes" or "No".](https://practiceexcelonline.com/practice/logical/if-or)
3. [**3****AND and OR in one test****Premium**Delivery is free only inside DK, and then only for orders of 500 or more OR for members. In E2, use IF with AND, and OR inside the AND, to show "Free" or "Paid".](https://practiceexcelonline.com/practice/logical/and-or-combined)
4. [**4****Check a value is within limits****Premium**In E2, show "OK" if the measurement in B2 is between the limits in C2 and D2, both included, and "Check" if not. Both tests must be true, so use AND inside IF.](https://practiceexcelonline.com/practice/logical/and-between-two-limits)

## **Functions in this topic**

- [**AND**](https://practiceexcelonline.com/functions/and)
- [**OR**](https://practiceexcelonline.com/functions/or)

## **Read the guide**

- [**Excel for job interviews: what gets tested and how to prepare**](https://practiceexcelonline.com/learn/excel-for-job-interviews)
- [**Excel IF formulas: from one condition to many**](https://practiceexcelonline.com/learn/excel-if-function)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/practice/logical#webpage","description":"Practice AND and OR inside IF in a live spreadsheet.","name":"AND and OR practice exercises","url":"https://practiceexcelonline.com/practice/logical","@type":["WebPage","CollectionPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/practice/logical#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/logical"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/logical#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://practiceexcelonline.com/practice","position":2},{"@type":"ListItem","name":"AND and OR practice exercises","position":3}]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```

## Sitemap

See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.