Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
IFNA. IFNA(value, fallback) shows the value, but when the value is #N/A (not found) it shows the fallback instead. Unlike IFERROR it leaves other errors visible, so a broken formula still shows up.
=IFNA(VLOOKUP(D2,K2:L40,2,FALSE),"New customer")
The coffee supplier sent a new Coffee & Kitchen price list (F1:G7). Purchasing wants the new prices next to August’s order lines, with a clear note on lines from other categories.
In C2:C11, look up each product’s price in F1:G7. When the product isn’t on that list, show "Not on list" instead of an error.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product ID | Qty | New price | Product ID | List price | |||
| 2 | 201 | 2 | 201 | $24.00 | ||||
| 3 | 304 | 2 | 202 | $16.50 | ||||
| 4 | 402 | 6 | 203 | $36.00 | ||||
| 5 | 302 | 2 | 204 | $19.90 | ||||
| 6 | 104 | 1 | 205 | $21.50 | ||||
| 7 | 205 | 3 | 206 | $11.00 | ||||
| 8 | 205 | 6 | ||||||
| 9 | 203 | 5 | ||||||
| 10 | 204 | 8 | ||||||
| 11 | 202 | 6 | ||||||
| 12 | ||||||||
| 13 | ||||||||
| 14 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe