Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
A revenue-ops analyst's tiered-discount formula computes the same subexpression — average order value (AOV = Revenue / Orders) — three times in one nested IF:
=IF(B2/C2 > 1000, B2*0.15, IF(B2/C2 > 500, B2*0.10, IF(B2/C2 > 100, B2*0.05, 0)))
That's three divisions per cell across thousands of rows in production. More importantly, when AOV's definition changes (e.g., to gross revenue instead of net), all three references need to be updated in lockstep. LET binds the expression to a name once.
Discount tiers (applied to Revenue, not AOV):
| AOV (Revenue / Orders) | Discount rate |
|---|---|
| Above $1,000 | 15% |
| $500 – $1,000 | 10% |
| $100 – $500 | 5% |
| $100 or below | 0% |
Your task:
Graded cells: D2 (Acme — high AOV → 15%), D3 (Globex — low AOV → 5%), D5 (Hooli — tiny AOV → 0%).