Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Fix the cause, not the total. When a total shows an error, one row above it has a problem. Leaving that row out of the total, or wrapping the total in IFERROR, makes the error disappear, but the number is now wrong. Trace the error back to the first cell that has it and fix the cause there.
=SUM(F2:F20) if this shows #N/A, find the row in F that does
A customer’s November order total showed #N/A. The AI assistant “fixed” it, and now the total in D10 looks normal.
AI assistant: “D9 showed #N/A and broke the order total, so I left row 9 out of the SUM in D10. The total works now.”
Fix C2:C9 so every line shows its price from the list in G1:H9, and fix D10 so it totals every line (D2:D9).
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product ID | Qty | Unit price | Line total | Product ID | List price | ||
| 2 | 201 | 5 | $24.00AI | $120.00 | 101 | $5.50 | ||
| 3 | 101 | 4 | $5.50AI | $22.00 | 102 | $6.20 | ||
| 4 | 401 | 14 | $9.50AI | $133.00 | 103 | $59.00 | ||
| 5 | 301 | 4 | $14.00AI | $56.00 | 201 | $24.00 | ||
| 6 | 103 | 5 | $59.00AI | $295.00 | 202 | $16.50 | ||
| 7 | 202 | 5 | $16.50AI | $82.50 | 301 | $14.00 | ||
| 8 | 102 | 5 | $6.20AI | $31.00 | 401 | $9.50 | ||
| 9 | 402 | 3 | #N/AAI | #N/A | 402 | $12.00 | ||
| 10 | Order total | $739.50AI | ||||||
| 11 | ||||||||
| 12 | ||||||||
| 13 |
=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