Excel 365
· 10 min read
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 maths instead — here's the SUMPRODUCT one-liner that works in every Excel, the 365 MAP version that spills the whole column, and a free workbook that proves both against a hand-built calculation.
Read article