IF function to increase rate question regarding logic

[PhoenixFaery]

In attempting to calculate percentage rate based on total sales of an individual using =IF(EmployeeTotalSales<=ToAmount,32%,BATier1Rate) I realized a logic issue because if the first sale of an individual was over the ToAmount which is $125.00, lets say $300.00, how would that calculate $0.00 - $125.00 (32%) + $125.01-$300.00 (BATier1Rate) which is 40%? Is a sum if function needed? I hope I have explained adequately.

[JBeaucaire]

This formula is a bit difficult to explain...

Commission sample
http://www.excelforum.com/attachment...ple-tiers-.xls

Here's a sample file that shows you an example of complex vs simple TIERED commission structures, looks like you want the complex one:

Complex vs Simple percentage techniques

Search the FILES page linked above for CommissionStructures(ComplexvsSimpleTiers).xls

[martindwilson]

maybe
=MIN(A1,250)*32%+MAX(A1-250,0)*40%

[PhoenixFaery]

Thank you Jerry for the file and the fast response. It helps me to better understand the logic. It's just what I needed.

[PhoenixFaery]

Wow Martin, I plugged your formula in and it worked like a charm. I can see many uses for the MIN and MAX functions. Thank you so much for expanding my knowledge on MIN and Max.