Excel OR Practice Question: Write Fail if any of the three marks is below 35, otherwise Pass. Put it in E2…
The question
Write Fail if any of the three marks is below 35, otherwise Pass. Put it in E2 to E4.
The data
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Name | Maths | Science | English | Result |
| 2 | Rahul | 60 | 70 | 55 | ? |
| 3 | Priya | 80 | 30 | 90 | ? |
| 4 | Amit | 34 | 60 | 60 | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- E2 = Pass
- E3 = Fail
- E4 = Fail
How it works
Explanation: OR can take many conditions. One failing mark is enough to fail the student.
Syntax: =IF(OR(B2<35,C2<35,D2<35),"Fail","Pass")
Rahul has no mark below 35: Pass. Priya has 30 in Science: Fail. Amit has 34 in Maths: Fail.
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 →OR syntax
=OR(logical1, [logical2], ...)
Returns TRUE if at least one condition given is true. OR is used to build decision rules directly into a spreadsheet instead of manually judging each row. Full OR guide.
More OR practice questions
- Write Weekend if the day is Sat or Sun, otherwise Weekday. Put it in C2 to C4.
- Write Out of range if the age is below 18 or above 60, otherwise OK. Put it in C2 to C4.
- Write West if the city is Pune or Mumbai, otherwise Other. Put it in C2 to C4.
- Give a Discount if the customer is a member (Yes) or the amount is above 5000, otherwise…
- Write Incomplete if the name or the city is empty, otherwise OK. Put it in C2 to C4.
- A customer is VIP if the level is Gold or Platinum and the spend is 1000 or more,…
- Count how many customers are from Pune or Surat (cities in B2:B6) and put the count in D2.
All practice questions · Excel exercises · Interview prep · Cheat sheet