Google Sheets Commission Calculation Formula
2026-03-18
Basic Commission
Multiply sales amount by commission rate. Sales in B, rate in C:
=B2*C2Tiered Commission with IFS
Different rates for different sales tiers (under $5K: 3%, $5-15K: 5%, over $15K: 8%):
=IFS(B2<5000, B2*0.03, B2<15000, B2*0.05, TRUE, B2*0.08)Team Total Commission
Sum all commissions for a specific team member named in column A:
=SUMIF(A:A, "Jane Smith", D:D)Generate formulas instantly
Describe what you need in plain English. Get the formula for Excel, Google Sheets, or Airtable.
Try FormulaWiz Free