Hi,

I am desperately trying to do a similar thing. My boss just gave me this spreadsheet and wants it done pronto.

I need to be able to enter the commission tier amounts as cells, not numbers, in case they change. Here is what I need:

Base salary paid
Up to 2.5 times base salary made in sales- 3%
Another 100000 on top of that is 20%
anything over that is 35%

So en example:
Base Salary 50000
up to 125000 earns 3% (3750)
125001 to 225000 earns 20% (20000)
over 225001 earns 35% (8750)
So commission earnt is $32,500 on top of $50,000.

How do I create a formula so that my boss can enter a different base salary and hypothetical sales amount and calculate the commission earnt?

PLEASE HELP! I will be forever grateful!!!