Practice by topic / Excel / Conditional Logic
To test more than one condition in an IF, put AND or OR inside it: =IF(AND(A2>=50,B2>=50),"Pass","Fail") returns Pass only when both are true, and OR returns true when either is. These exercises cover both, plus "between" checks and AND nested inside OR. These 10 exercises build up step by step, starting with pass only if both scores are 50+, approve a claim under the limit with a receipt, free shipping for big orders or members.
3 of 10 free · no sign-up needed · graded on the formula you write
A2 holds a theory score and B2 a practical score. Write a formula in C2 that returns 'Pass' only if both scores are 50 or more, otherwise 'Fail'.
| A | B | C | |
|---|---|---|---|
| 1 | Theory | Practical | |
| 2 | 68 | 45 | ? |
Use =IF(AND(A2>=50,B2>=50),"Pass","Fail")
Right — AND is TRUE only when every condition is TRUE, so one low score is enough to fail.
Expected result in C2: Fail
A2 holds a claim amount and B2 says whether a receipt was attached (Yes or No). Write a formula in C2 that returns 'Approve' if the amount is 200 or less and B2 is "Yes", otherwise 'Review'.
| A | B | C | |
|---|---|---|---|
| 1 | Amount | Receipt | |
| 2 | 180 | Yes | ? |
Use =IF(AND(A2<=200,B2="Yes"),"Approve","Review")
Good — AND lets one IF check a number and a text value at the same time.
Expected result in C2: Approve
A2 holds an order total and B2 says whether the customer is a member (Yes or No). Write a formula in C2 that returns a shipping fee of 0 if the total is 50 or more or the customer is a member, otherwise 5.
| A | B | C | |
|---|---|---|---|
| 1 | Order total | Member | |
| 2 | 42 | Yes | ? |
Use =IF(OR(A2>=50,B2="Yes"),0,5)
Right — OR is TRUE when any one condition is TRUE, so membership alone earns free shipping.
Expected result in C2: 0
A2 holds a day name (Mon to Sun). Write a formula in B2 that returns 'Weekend rate' if A2 is "Sat" or "Sun", otherwise 'Standard rate'.
| A | B | |
|---|---|---|
| 1 | Day | |
| 2 | Sun | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A2 holds a salesperson's sales and B2 their days absent. Write a formula in C2 that returns a bonus of 500 if sales are at least 50000 and days absent are 2 or fewer, otherwise 0.
| A | B | C | |
|---|---|---|---|
| 1 | Sales | Days absent | |
| 2 | 52000 | 1 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A2 holds a fridge temperature. It must be between 2 and 8 inclusive. Write a formula in B2 that returns 'OK' if A2 is in that range, otherwise 'Out of range'.
| A | B | |
|---|---|---|
| 1 | Fridge temp (°C) | |
| 2 | 9 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A2 holds a ticket's priority and B2 how many days it has been open. Write a formula in C2 that returns 'Escalate' if the priority is "High" or the ticket has been open more than 10 days, otherwise 'Normal'.
| A | B | C | |
|---|---|---|---|
| 1 | Priority | Days open | |
| 2 | Low | 12 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A2 holds a credit score and B2 an annual income. An applicant is eligible if the score is 700 or more, or if the score is at least 650 and income is at least 80000. Write a formula in C2 that returns 'Eligible' or 'Not eligible'.
| A | B | C | |
|---|---|---|---|
| 1 | Credit score | Income | |
| 2 | 670 | 85000 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A2 holds attendance %, B2 says whether assignments are "Done", and C2 holds an exam score. Write a formula in D2 that returns 'Certified' if attendance is at least 80, assignments are "Done" and the exam score is at least 50, otherwise 'Not yet'.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Attendance % | Assignments | Exam | |
| 2 | 92 | Done | 58 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A2 holds a region and B2 a sales amount. Write a formula in C2 that returns the commission: 5% of sales if the region is "East" or "West", otherwise 3%.
| A | B | C | |
|---|---|---|---|
| 1 | Region | Sales | |
| 2 | East | 20000 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →