Formuladrill

Level 7: Find the error Exercise 117 of 118

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?

Functions used: IF

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 exercise

More exercises in Find the error