Grades tested in the wrong order
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
Grades should be A from 90, B from 80, C from 70 and F below 70. Two students have the wrong grade, and the same formula sits in every row. Fix it in C2:C5.
What this exercise teaches
Nested IFs must run from the strictest test to the loosest. Testing >=70 first catches every passing score, so the B and A branches can never be reached. Rows that happen to show the right grade still hold the wrong formula.
A hint if you get stuck
A nested IF stops at the first test that is true. A score of 91 is also at least 70, so which test does it meet first?
Try it now, free, no account needed
Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Find the error
- The budget that looks fine
- A rate typed into a formula
- Commission copied down
- Growth that does not add up
- The wrong price column
- An average with the wrong count
- A region total that misses a row
- A loan payment that is far too high
- Variance with the wrong sign
- A count that ignores its threshold
- The lookup without FALSE
- An NPV discounted one year too many
- A growth rate over the wrong number of years