Excel OR Practice Question: Write Incomplete if the name or the city is empty, otherwise OK. Put it in C2…
The question
Write Incomplete if the name or the city is empty, otherwise OK. Put it in C2 to C4.
The data
| A | B | C | |
|---|---|---|---|
| 1 | Name | City | Check |
| 2 | Rahul | Pune | ? |
| 3 | Delhi | ? | |
| 4 | Amit | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- C2 = OK
- C3 = Incomplete
- C4 = Incomplete
How it works
Explanation: An empty cell is equal to empty text, so OR can catch a missing value in either column.
Syntax: =IF(OR(A2="",B2=""),"Incomplete","OK")
Rahul has both values: OK. The second row has no name: Incomplete. The third row has no city: Incomplete.
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 Fail if any of the three marks is below 35, otherwise Pass. Put it in E2 to E4.
- 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