Excel IF Practice Question: The pass mark is 40. Scores are in B2:B7. Show Pass or Fail for each student…
The question
The pass mark is 40. Scores are in B2:B7. Show Pass or Fail for each student in D2:D7.
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Student | Score | Result | |
| 2 | Aarav | 72 | ? | |
| 3 | Diya | 38 | ? | |
| 4 | Ishaan | 55 | ? | |
| 5 | Kavya | 40 | ? | |
| 6 | Rohit | 29 | ? | |
| 7 | Tanvi | 91 | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- D2 = Pass
- D3 = Fail
- D4 = Pass
- D5 = Pass
- D6 = Fail
- D7 = Pass
How it works
Explanation: IF returns one result when the test is true and another when it is false. A score of exactly 40 is a pass, so use >=.
Syntax: =IF(B2>=40,"Pass","Fail")
Fill down D2:D7. 38 and 29 are Fail, the rest are Pass.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →IF syntax
=IF(logical_test, value_if_true, value_if_false)
Returns one value if a condition is true, another if false. Flagging an employee as Pass or Fail based on a score cutoff. Full IF guide.
More IF practice questions
- Using IF, show Pass if the marks are 40 or more, otherwise Fail. Fill C2 to C4.
- Show Reorder when the stock is below 20 and OK otherwise. Fill C2 to C4.
- Using IF, give a 5% bonus on sales above 50000 and 0 otherwise. Fill C2 and C3.
- A candidate is Eligible only if the age is 18 or above and the score is 60 or above.…
- Using IF with OR, show Free if the order is 1000 or more or the customer is a member,…
- A blank Days cell means the order is not delivered yet. Show Done if Days has a value…
- Using nested IF, assign grades: 90 and above is A, 75 to 89 is B, 50 to 74 is C, below…
- Using nested IF with these simplified slabs, find the tax: nothing up to 250000; 5% of…
All practice questions · Excel exercises · Interview prep · Cheat sheet