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

E2
ABCDEF
1Customer Country Order total Member Free delivery?
2Ane 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 SWITCHConditional formatting

It comes up in this mock test: Excel test for job interviews

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?