Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Reading #VALUE!. #VALUE! means a formula did maths on something that isn’t a number, usually text such as "pending" or "n/a" in a number column. Find the text the formula uses. Then decide what that row should show, and test for it with IF and ISNUMBER, or catch it with IFERROR.
=IF(ISNUMBER(C2),C2*1.2,"") blank where C2 is text
The carrier export writes "pending" when a parcel hasn’t arrived. The AI assistant worked out days in transit for late December, and some rows show #VALUE!.
AI assistant: “Done! E2:E33 shows the days each parcel spent in transit.”
Fix E2:E33 so delivered rows show the days from shipped (C) to delivered (D), and "pending" rows show an empty result ("").
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Carrier | Shipped | Delivered | Days in transit | |||
| 2 | 51066 | ParcelLine | 2025-12-21 | 2025-12-25 | 4AI | |||
| 3 | 51067 | ParcelLine | 2025-12-21 | 2025-12-24 | 3AI | |||
| 4 | 51071 | Greenway Logistics | 2025-12-22 | 2025-12-23 | 1AI | |||
| 5 | 51068 | ParcelLine | 2025-12-23 | 2025-12-25 | 2AI | |||
| 6 | 51069 | ParcelLine | 2025-12-23 | 2025-12-25 | 2AI | |||
| 7 | 51072 | Greenway Logistics | 2025-12-23 | 2025-12-24 | 1AI | |||
| 8 | 51073 | ParcelLine | 2025-12-23 | 2025-12-25 | 2AI | |||
| 9 | 51074 | Greenway Logistics | 2025-12-23 | 2025-12-24 | 1AI | |||
| 10 | 51070 | Greenway Logistics | 2025-12-24 | 2025-12-26 | 2AI | |||
| 11 | 51075 | Rapid Freight | 2025-12-24 | 2025-12-25 | 1AI | |||
| 12 | 51078 | ParcelLine | 2025-12-24 | 2025-12-27 | 3AI | |||
| 13 | 51079 | ParcelLine | 2025-12-24 | 2025-12-28 | 4AI | |||
| 14 | 51076 | ParcelLine | 2025-12-25 | 2025-12-27 | 2AI | |||
| 15 | 51077 | Rapid Freight | 2025-12-25 | 2025-12-26 | 1AI | |||
| 16 | 51085 | ParcelLine | 2025-12-25 | 2025-12-28 | 3AI | |||
| 17 | 51080 | Rapid Freight | 2025-12-26 | 2025-12-30 | 4AI | |||
| 18 | 51081 | Rapid Freight | 2025-12-26 | 2025-12-27 | 1AI | |||
| 19 | 51084 | Rapid Freight | 2025-12-26 | 2025-12-31 | 5AI | |||
| 20 | 51082 | ParcelLine | 2025-12-27 | 2025-12-29 | 2AI | |||
| 21 | 51083 | Greenway Logistics | 2025-12-27 | 2025-12-30 | 3AI | |||
| 22 | 51087 | Rapid Freight | 2025-12-27 | 2025-12-29 | 2AI | |||
| 23 | 51088 | Rapid Freight | 2025-12-27 | 2025-12-30 | 3AI | |||
| 24 | 51086 | ParcelLine | 2025-12-28 | 2025-12-31 | 3AI | |||
| 25 | 51089 | ParcelLine | 2025-12-28 | 2025-12-31 | 3AI | |||
| 26 | 51091 | Greenway Logistics | 2025-12-29 | 2025-12-31 | 2AI | |||
| 27 | 51092 | ParcelLine | 2025-12-29 | pending | #VALUE!AI | |||
| 28 | 51093 | Greenway Logistics | 2025-12-29 | 2025-12-31 | 2AI | |||
| 29 | 51090 | Rapid Freight | 2025-12-30 | 2025-12-31 | 1AI | |||
| 30 | 51094 | Greenway Logistics | 2025-12-30 | pending | #VALUE!AI | |||
| 31 | 51095 | Rapid Freight | 2025-12-30 | 2025-12-31 | 1AI | |||
| 32 | 51097 | ParcelLine | 2025-12-31 | pending | #VALUE!AI | |||
| 33 | 51100 | ParcelLine | 2025-12-31 | pending | #VALUE!AI | |||
| 34 | ||||||||
| 35 | ||||||||
| 36 |
=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