=IF(A1<=10,0,IF(A1<=20,2.5,IF(A1<=30,5,....

Regards

Trevor


"Johanna" wrote in message
...
I am trying to create an automated commission calculation sheet for my
sales
team, however I can't find how to create the formula.

What I'd like to achieve is the following:

revenue:
0 - 10 == no commission
10.1 - 20 == 2.5% commission of the amount over and above 10
20.1 - 30 == 5% commission of the amount over and above 20
etc.

The formula I created now double counts the amount of revenue and that is
not the intention.

Thank you for your help!