Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Practice
  2. /
  3. IF function

IF function practice: Pass or Fail for 60 exam scores

  • Beginner
  • ~4 min
  • IF function

The training department ran the final exam of a six-week spreadsheet course for 60 employees in three sections (Morning, Evening, Online). Scores are out of 100 and the pass mark is 60: a score of exactly 60 passes. HR wants a Result column that reads Pass or Fail on every row so the certificates can be printed from a filter, and it must still be right when a score is corrected later.

What you need to do

  1. 1Click E2. The score for this student is in D2 and the pass mark is 60.
  2. 2Enter an IF formula with three parts: the test (is D2 at least 60?), the text to show when the test is true ("Pass") and the text to show otherwise ("Fail"). Put the two words in double quotes.
  3. 3Press Enter, then fill E2 down to E61: double-click the fill handle (the small square at the bottom-right corner of E2), or select E2:E61 and press Ctrl+D (Windows) / ⌘D (Mac).
  4. 4Spot-check a student with exactly 60 points — the cell must say Pass — then click Check (Ctrl+Enter / ⌘+Return).

Answer cells

Feedback

Type your formula in the grid, press Enter, then Check. We grade the value in each answer cell and the formula behind it.

Tasks

  1. Not checkedIn E2, write an IF formula that shows "Pass" when the score in D2 is 60 or more and "Fail" otherwise, then fill it down to E61.

Desktop recommended for spreadsheet tasks. The sheet scrolls inside this box.

StartInsertFormulasDataView
A1fxPreparing your workbook…
A
B
C
D
E
F
G
H
I
J
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Sheet1

Enter your formula in the sheet, then check.

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.

In these programs

  • Excel test in 7 days, Level 1 planDay 6
  • Excel for Administrative AssistantsDay 3
  • Learn Excel From ScratchDay 5

Related exercises

  • Bonus eligibility with IF and ANDBeginner, ~5 min
  • Free-shipping flag with IF and ORBeginner, ~6 min
  • Commission tiers with nested IF, IFS or a lookupIntermediate, ~8 min

Function reference

Official documentation

Next exercise

Bonus eligibility with IF and AND