IF practice exercises
Returns one value if a test is true, another if false. 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 | 6801 | West | Omar | 8 | 15 | 120 |
| 3 | 6802 | North | Kofi | 8 | 12 | 96 |
| 4 | 6803 | South | Kofi | 1 | 24 | 24 |
| 5 | 6804 | South | Lena | 3 | 15 | 45 |
| 6 | 6805 | South | Kofi | 2 | 12 | 24 |
| 7 | 6806 | East | Maya | 4 | 18 | 72 |
| 8 | 6807 | East | Maya | 5 | 15 | 75 |
| 9 | 6808 | West | Omar | 7 | 45 | 315 |
Show "Big" if order 6802’s Revenue is at least 75, otherwise "Small".
Show answer
=IF(F3>=75,"Big","Small")→ BigShow "Big" if order 6806’s Revenue is at least 50, otherwise "Small".
Show answer
=IF(F7>=50,"Big","Small")→ BigShow "Big" if order 6804’s Revenue is at least 75, otherwise "Small".
Show answer
=IF(F5>=75,"Big","Small")→ SmallShow "Big" if order 6807’s Revenue is at least 100, otherwise "Small".
Show answer
=IF(F8>=100,"Big","Small")→ SmallShow "Big" if order 6805’s Revenue is at least 50, otherwise "Small".
Show answer
=IF(F6>=50,"Big","Small")→ SmallShow "Big" if order 6805’s Revenue is at least 100, otherwise "Small".
Show answer
=IF(F6>=100,"Big","Small")→ Small
New to IF? Read the IF guide first: syntax, a worked example and common mistakes.