FormuladrillPercent change
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Work out how much each line grew compared with last year, as a percentage of last year. Use D2 for revenue and D3 for costs.
What this exercise teaches
Brackets control the order of operations. Without them, Excel divides before it subtracts.
A hint if you get stuck
Change divided by the starting point: (new minus old) divided by old. Mind the brackets.
Try it now, no account needed
This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this exercise