Sumproduct

Tiered Commission Formulas in Excel 365: Why VLOOKUP Gets It Wrong

VLOOKUP hands the whole amount one flat rate. Graduated commission, tax brackets and bulk pricing need marginal math instead — here's the fix, the old-school way and the shiny 365 way, plus a free workbook.