---
title: "AND and OR in one test | PracticeExcel"
description: "Practice IF with AND and OR together in a live spreadsheet: work out free delivery from three conditions."
canonical_url: "https://practiceexcelonline.com/practice/logical/and-or-combined"
locale: en
meta:
  "og:description": "Practice IF with AND and OR together in a live spreadsheet: work out free delivery from three conditions."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_AND%2Band%2BOR%2Bin%2Bone%2Btest%2Cdescription_~UHJhY3RpY2UgSUYgd2l0aCBBTkQgYW5kIE9SIHRvZ2V0aGVyIGluIGEgbGl2ZSBzcHJlYWRzaGVldDogd29yayBvdXQgZnJlZSBkZWxpdmVyeSBmcm9tIHRocmVlIGNvbmRpdGlvbnMu%2Ceyebrow_AND%2Band%2BOR%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJDdXN0b21lciIsIkNvdW50cnkiLCJPcmRlciB0b3RhbCIsIkZyZWUgZGVsaXZlcnk~Il19LHsibiI6MiwiY2VsbHMiOlsiQW5lIiwiREsiLCIzMjAiLCIiXX1dLCJ0YXJnZXQiOlsxLDNdfX0%2Cp_Ii9wcmFjdGljZS9sb2dpY2FsL2FuZC1vci1jb21iaW5lZCI%2Cs_BF55nORmp9pfyAnf.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "AND and OR in one test | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_AND%2Band%2BOR%2Bin%2Bone%2Btest%2Cdescription_~UHJhY3RpY2UgSUYgd2l0aCBBTkQgYW5kIE9SIHRvZ2V0aGVyIGluIGEgbGl2ZSBzcHJlYWRzaGVldDogd29yayBvdXQgZnJlZSBkZWxpdmVyeSBmcm9tIHRocmVlIGNvbmRpdGlvbnMu%2Ceyebrow_AND%2Band%2BOR%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJDdXN0b21lciIsIkNvdW50cnkiLCJPcmRlciB0b3RhbCIsIkZyZWUgZGVsaXZlcnk~Il19LHsibiI6MiwiY2VsbHMiOlsiQW5lIiwiREsiLCIzMjAiLCIiXX1dLCJ0YXJnZXQiOlsxLDNdfX0%2Cp_Ii9wcmFjdGljZS9sb2dpY2FsL2FuZC1vci1jb21iaW5lZCI%2Cs_BF55nORmp9pfyAnf.png"
---

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

# **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".

E2fx

|  | A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Customer | Country | Order total | Member | Free delivery? | |
| 2 | Ane | DK | 320 | Yes |  | |
| 3 |  |  |  |  |  | |
| 4 |  |  |  |  |  | |
| 5 |  |  |  |  |  | |
| 6 |  |  |  |  |  | |
| 7 |  |  |  |  |  | |
| 8 |  |  |  |  |  | |

**Premium lesson**

## **Unlock AND and OR and every other lesson**

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:**IFS and SWITCH****Conditional formatting**

It comes up in this mock test: [**Excel test for job interviews**](https://practiceexcelonline.com/tests/excel-test-for-job-interview)

[**See plans, from $5/month**](https://practiceexcelonline.com/pricing) [**Already premium? Sign in**](https://practiceexcelonline.com/login?next=/practice/logical/and-or-combined)

Need help?

```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/and-or-combined#webpage","description":"Practice IF with AND and OR together in a live spreadsheet: work out free delivery from three conditions.","name":"AND and OR in one test","url":"https://practiceexcelonline.com/practice/logical/and-or-combined","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/practice/logical/and-or-combined#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/practice/logical/and-or-combined#/schema/question/1"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/logical/and-or-combined"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/logical/and-or-combined#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","item":"https://practiceexcelonline.com/practice/logical","position":3},{"@type":"ListItem","name":"AND and OR in one test","position":4}]},{"@id":"https://practiceexcelonline.com/practice/logical/and-or-combined#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Can I use AND and OR in the same IF?","acceptedAnswer":{"@type":"Answer","text":"Yes. Put one inside the other, for example =IF(AND(B2=\"DK\",OR(C2>=500,D2=\"Yes\")),\"Free\",\"Paid\")."}},{"@id":"https://practiceexcelonline.com/practice/logical/and-or-combined#/schema/learning-resource/1","@type":"LearningResource","description":"Practice IF with AND and OR together in a live spreadsheet: work out free delivery from three conditions.","educationalLevel":"intermediate","isAccessibleForFree":false,"learningResourceType":"exercise","name":"AND and OR in one test","teaches":"AND and OR"},{"@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.