Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
IF. IF(test, value if true, value if false) picks between two answers. Tests use > < >= <= = and text goes in double quotes.
=IF(B2>1000,"Big","Small")
Each region has a January target. Your manager wants a simple label per region.
In D2:D5, show "Hit" when the actual (B) is at least the target (C), otherwise "Missed".
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Region | Actual | Target | Result | ||||
| 2 | North | 7330.02 | 7000 | |||||
| 3 | South | 7903.87 | 8200 | |||||
| 4 | East | 4945.97 | 5100 | |||||
| 5 | West | 9006.93 | 8500 | |||||
| 6 | ||||||||
| 7 | ||||||||
| 8 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe