About this exercise
A 60-row dataset on one sheet, one answer cell, about 4 minutes. Graded in your browser: the value and the formula behind it, with feedback that names the fix.
How to solve it
- E2
=IF(D2>=60,"Pass","Fail")
IF evaluates a test and returns one of two values: =IF(D2>=60,"Pass","Fail") asks "is the score at least 60?" and answers Pass when it is and Fail when it is not. The test uses >= (greater than or equal) because the pass mark itself passes. Because the formula points at D2 rather than containing the score, filling it down gives every row its own verdict, and correcting a score updates the result immediately.
Pitfall 1: writing > instead of >= moves the boundary — the 3 students with exactly 60 points would be marked Fail, which is the kind of error nobody notices until a student complains. Pitfall 2: text results need quotes; =IF(D2>=60,Pass,Fail) returns #NAME? because Excel looks for named ranges called Pass and Fail. Pitfall 3: a blank score is treated as 0 and reads Fail — wrap the test in IF(D2="","",…) when the data can have gaps. Design: keep the pass mark in its own cell (for example G1) and reference it as $G$1, so a change by the exam board is one edit instead of 60 formula changes; that is exactly what the next exercises in this track practise. Alternatives: IFS(D2>=60,"Pass",TRUE,"Fail") reads the same in Excel 2019 and later; for more than two outcomes (Distinction / Pass / Fail) use IFS or a nested IF.
Other ways that work
- =IF(D2<60,"Fail","Pass") — the same test written the other way round
- =IFS(D2>=60,"Pass",TRUE,"Fail") — Excel 2019 and later; TRUE is the catch-all branch
- =IF(D2>=60,"Pass","Fail") with the pass mark moved to a cell: =IF(D2>=$G$1,"Pass","Fail")
Common mistakes
Testing D2>60 instead of D2>=60: the formula looks right on most rows, but every student with exactly 60 points is marked Fail — the grader names the first of those cells.
How we grade
Any formula that produces the right result is accepted, unless the task names a function: then another function earns half credit. We compare values with a small tolerance and ignore case and spaces in text. A correct number typed by hand instead of a formula earns half credit. Multi-cell tasks earn full credit at 100% of cells, half credit from 50%. Where it matters, we also change an input cell on a copy of your sheet and check that your formula follows.
Answers computed with Excel 365 rules and checked in our grading engine on November 16, 2026. Author: GridBelt team.