Excel OR Practice Question: Write Out of range if the age is below 18 or above 60, otherwise OK. Put it in…
The question
Write Out of range if the age is below 18 or above 60, otherwise OK. Put it in C2 to C4.
The data
| A | B | C | |
|---|---|---|---|
| 1 | Name | Age | Check |
| 2 | Rahul | 25 | ? |
| 3 | Priya | 16 | ? |
| 4 | Amit | 65 | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- C2 = OK
- C3 = Out of range
- C4 = Out of range
How it works
Explanation: OR checks both ends. One true condition is enough to give Out of range.
Syntax: =IF(OR(B2<18,B2>60),"Out of range","OK")
25 is fine: OK. 16 is below 18: Out of range. 65 is above 60: Out of range.
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 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 Fail if any of the three marks is below 35, otherwise Pass. Put it in E2 to E4.
- 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