Excel IF Practice Question: A blank Days cell means the order is not delivered yet. Show Done if Days has…
The question
A blank Days cell means the order is not delivered yet. Show Done if Days has a value and Pending if it is blank. Fill C2 to C4.
The data
| A | B | C | |
|---|---|---|---|
| 1 | Order | Days | Status |
| 2 | O-1 | 3 | ? |
| 3 | O-2 | ? | |
| 4 | O-3 | 5 | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- C2 = Done
- C3 = Pending
- C4 = Done
How it works
Explanation: Comparing a cell with empty quotes ("") checks whether it is blank.
Syntax: =IF(B2="","Pending","Done")
O-1 has 3 days, so Done. O-2 is blank, so Pending. O-3 has 5 days, so Done.
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,…
- 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…
- Compare the year's total sales with the target in E2. If the target is met show Target…
All practice questions · Excel exercises · Interview prep · Cheat sheet