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 check two conditions with and, check either condition with or, invert a condition with not.
3 of 10 free · no sign-up needed · graded on the formula you write
A2 holds an age, B2 holds a years-of-experience value. Write a formula in C2 that returns TRUE only if A2 is 18+ AND B2 is 2+.
| A | B | C | |
|---|---|---|---|
| 1 | |||
| 2 | 22 | 3 | ? |
Use =AND(A2>=18,B2>=2).
Right — AND requires every condition to be TRUE for the whole formula to return TRUE.
Expected result in C2: true
A2 holds a status flag, B2 holds a backup status flag. Write a formula in C2 that returns TRUE if A2 is 'urgent' OR B2 is 'urgent'.
| A | B | C | |
|---|---|---|---|
| 1 | |||
| 2 | normal | urgent | ? |
Use =OR(A2="urgent",B2="urgent")
Good — OR returns TRUE if at least one of the conditions is TRUE.
Expected result in C2: true
A2 holds a completion flag as TRUE/FALSE style boolean via a comparison. Write a formula in B2 that returns TRUE only when A2 is NOT greater than 100.
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 50 | ? |
Wrap the comparison in NOT: =NOT(A2>100)
Right — NOT flips the boolean result of the inner comparison.
Expected result in B2: true
A2 holds a score, B2 holds attendance percentage. Write a formula in C2 that returns 'Qualified' only if A2 is 70+ AND B2 is 90+, otherwise 'Not Qualified'.
| A | B | C | |
|---|---|---|---|
| 1 | |||
| 2 | 75 | 95 | ? |
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, B2 holds another region field for a secondary warehouse. Write a formula in C2 that returns 'Ships Today' if either A2 or B2 equals 'Local', otherwise 'Ships Later'.
| A | B | C | |
|---|---|---|---|
| 1 | |||
| 2 | Remote | Local | ? |
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, B2, C2 each hold a pass/fail-style numeric check. Write a formula in D2 that returns TRUE only if A2>0 AND B2>0 AND C2>0.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ||||
| 2 | 5 | 3 | 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 →A2 holds a name length, B2 holds an email length (0 means missing). Write a formula in C2 that returns TRUE if either field is missing (length 0), using OR.
| A | B | C | |
|---|---|---|---|
| 1 | |||
| 2 | 5 | 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 a stock count. Write a formula in B2 that returns TRUE when the item is NOT out of stock (not equal to 0).
| A | B | |
|---|---|---|
| 1 | ||
| 2 | 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 order total, B2 holds a loyalty-member flag ('yes'/'no'). Write a formula in C2 that returns 'Discount' only if A2 is over 100 AND B2 is 'yes'.
| A | B | C | |
|---|---|---|---|
| 1 | |||
| 2 | 150 | yes | ? |
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 manager approval ('yes'/'no'), B2 holds director approval ('yes'/'no'). Write a formula in C2 that returns 'Approved' if either A2 or B2 is 'yes'.
| A | B | C | |
|---|---|---|---|
| 1 | |||
| 2 | no | yes | ? |
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 →