Practice by topic / Excel / Conditional Logic
IF-style formulas let a spreadsheet make decisions — pass or fail, on time or late, which rate applies — so you don't have to check each row by hand. These 10 exercises build up step by step, starting with pass or fail a test score, flag overdue invoices, label inventory as low or ok.
3 of 10 free · no sign-up needed · graded on the formula you write
A2 holds a test score. Write a formula in B2 that returns 'Pass' if A2 is 60 or higher, and 'Fail' otherwise.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 72 | ? |
Structure it as =IF(condition, value_if_true, value_if_false): =IF(A2>=60,"Pass","Fail")
Nice — =IF(A2>=60,"Pass","Fail") covers both outcomes with a single condition.
Expected result in B2: Pass
A2 holds days since an invoice was issued. Write a formula in B2 that returns 'Overdue' if A2 is over 30, otherwise 'Current'.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 45 | ? |
Use =IF(A2>30,"Overdue","Current")
Right — comparing days against 30 and branching gives an immediate status label.
Expected result in B2: Overdue
A2 holds a stock count. Write a formula in B2 that returns 'Low Stock' if A2 is under 10, otherwise 'OK'.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 6 | ? |
Use =IF(A2<10,"Low Stock","OK")
Good — a simple threshold IF is exactly what inventory alerts need.
Expected result in B2: Low Stock
A2 holds a sales total. Write a formula in B2 that returns 'Eligible' if A2 is at least 10000, otherwise 'Not Eligible'.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 12000 | ? |
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 temperature. Write a formula in B2 that returns 'Hot' if A2 is above 85, otherwise 'Cold'.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 90 | ? |
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 hours attended out of a possible 8. Write a formula in B2 that returns 'Present' if A2 is greater than 0, otherwise 'Absent'.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 0 | ? |
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 an order total. Write a formula in B2 that returns 'Free' if A2 is 75 or more, otherwise 'Paid'.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 80 | ? |
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 sensor reading. Write a formula in B2 that returns 'Alert' if A2 exceeds 100, otherwise 'Normal'.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 105 | ? |
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 customer's number of purchases. Write a formula in B2 that returns 'Gold' if A2 is at least 20, otherwise 'Standard'.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 25 | ? |
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 days early or late (negative means late). Write a formula in B2 that returns 'On Time' if A2 is 0 or more, otherwise 'Late'.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | -2 | ? |
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 →