Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
XLOOKUP if_not_found. XLOOKUP has an optional fourth part: what to return when the value isn’t in the list. A fallback of 0 instead of #N/A keeps later sums working. Choose a fallback that is true for missing items.
=XLOOKUP(A2,K2:K9,L2:L9,"None") shows None for an unknown code
Finance is booking 2025 volume rebates. Only the customers in the rebate table (H1:I5) have a deal; everyone else gets nothing.
In D2:D11, work out each customer’s rebate: 2025 revenue × their rate from H1:I5. Customers not in the table get 0, not an error. Round to 2 decimals.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Customer | Segment | 2025 revenue | Rebate | Customer | Rebate rate | |||
| 2 | Orchard Clinic | Enterprise | $12,170.74 | Harbor & Pine Hotels | 4% | ||||
| 3 | Atlas Realty | Mid-Market | $7,682.08 | Orchard Clinic | 3% | ||||
| 4 | Oak Academy | Mid-Market | $7,645.20 | Oak Academy | 2% | ||||
| 5 | Bright Pharmacy | Enterprise | $6,912.40 | Harbor Consulting | 2% | ||||
| 6 | Summit Realty | Enterprise | $6,910.83 | ||||||
| 7 | Harbor Consulting | Enterprise | $6,738.41 | ||||||
| 8 | Willow Studios | Mid-Market | $6,652.73 | ||||||
| 9 | Orchard Print Co | Mid-Market | $5,743.66 | ||||||
| 10 | Harbor Labs | Mid-Market | $3,703.34 | ||||||
| 11 | Oak Studios | SMB | $2,542.60 | ||||||
| 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