Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
West's H2 numbers go to the regional review. December's target hasn't been entered yet.
In D2:D7, calculate Actual ÷ Target. Where there's no target, show an empty result ("") instead of an error.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Month | Actual | Target | % of target | ||||
| 2 | Jul | 3748.09 | 11290 | |||||
| 3 | Aug | 5165.56 | 11865 | |||||
| 4 | Sep | 6450.74 | 11199 | |||||
| 5 | Oct | 6981.98 | 11816 | |||||
| 6 | Nov | 3582.09 | 11505 | |||||
| 7 | Dec | 5176.05 | ||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 |
=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