All Posts

Excel Formula for Sales Commission: Complete Guide

2026-03-18

Flat Rate Commission

The simplest commission formula multiplies sales by a fixed percentage. This gives you 5% of the value in B2.

=B2*0.05

Tiered Commission

For tiered commission (e.g., 5% on first $10,000, 8% on everything above):

=IF(B2<=10000, B2*0.05, 10000*0.05 + (B2-10000)*0.08)

Sum All Commissions

To total all commissions across a column:

=SUM(B2:B100)*0.05

Generate formulas instantly

Describe what you need in plain English. Get the formula for Excel, Google Sheets, or Airtable.

Try FormulaWiz Free