AND practice exercises
TRUE only if every test is true. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 6201 | South | Maya | 1 | 12 | 12 |
| 3 | 6202 | East | Raj | 4 | 45 | 180 |
| 4 | 6203 | North | Raj | 4 | 18 | 72 |
| 5 | 6204 | East | Omar | 7 | 24 | 168 |
| 6 | 6205 | North | Kofi | 4 | 15 | 60 |
| 7 | 6206 | South | Kofi | 2 | 9 | 18 |
| 8 | 6207 | East | Maya | 1 | 30 | 30 |
| 9 | 6208 | North | Kofi | 4 | 9 | 36 |
Return "Yes" if order 6206 is from South and sold more than 5 units, otherwise "No".
Show answer
=IF(AND(B7="South",D7>5),"Yes","No")→ NoReturn "Yes" if order 6201 is from South and sold more than 3 units, otherwise "No".
Show answer
=IF(AND(B2="South",D2>3),"Yes","No")→ NoReturn "Yes" if order 6203 is from South and sold more than 3 units, otherwise "No".
Show answer
=IF(AND(B4="South",D4>3),"Yes","No")→ NoReturn "Yes" if order 6202 is from East and sold more than 4 units, otherwise "No".
Show answer
=IF(AND(B3="East",D3>4),"Yes","No")→ NoReturn "Yes" if order 6207 is from East and sold more than 3 units, otherwise "No".
Show answer
=IF(AND(B8="East",D8>3),"Yes","No")→ NoReturn "Yes" if order 6208 is from North and sold more than 4 units, otherwise "No".
Show answer
=IF(AND(B9="North",D9>4),"Yes","No")→ No
New to AND? Read the AND guide first: syntax, a worked example and common mistakes.