Commission sum of question

[dowcraig]

Good morning
I am creating a spreadsheet that needs the following and I'm having trouble creating this formula.

I earn commission and I am charged a specific percentage of my sales until I reach a specific sales volume number , say 15% and charged a different percentage once I reach another total sales volume, say 10%.

For example, once the values of cells H5 to H33 reaches $50,000, I am charged 10% but for anything below $50,000, I'm charged 15%. To complicate matters, I'm still charged the 15% on the first $50,000.

Any thoughts?

Thanks
Craig

 

[arthurbr]

Have a look at http://www.mcgimpsey.com/excel/variablerate1.html

 

[dowcraig]

That was basically what I needed. I needed to make a few changes to it, but works like a charm. Thanks for the help!