Calculating Commission based on tiers

[SpudNix]

Hi there

I’m trying to get a formula that calculates commission based on sales tiers.
So in the below example

A. B. C. % Commission
1. 0. 250,000. 0.3
2. 250,001. 500,000. 0.21
3. 500,001. 1,000,000. 0.15
4. 1,000,001. 3,000,000. 0.06

So if my sales is $550k, then my commission is $135k.

The tiers often change and as such the formula needs to reference the cells containing the tiers rather than the tier values themselves.

 

[SpudNix]

My spacing got messed up but basically the tiers are in columns A and B. Commission is in column C

 

[Dave Patton]

see your other post
https://www.mrexcel.com/forum/excel-questions/1024525-will-sumproduct-work-commission-tiers.html