FormuladrillA rate typed into a formula
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
Every price should include the tax rate in F1. The numbers all look right today, but one formula will break when the rate changes. Find it and fix it.
What this exercise teaches
A number typed into a formula gives the right answer until the input changes, and nothing warns you. That is why the checker also tests the sheet with a different tax rate.
A hint if you get stuck
Compare the formulas, not the results. One of them does not point at F1.
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