Hello
Could you assist me with a formula(s) to do a tiered commission structure

Tier 1 below 79.99% = 0% commission
Tier 2 80% to 99.99% = 10% commission
Tier 3 100% to 119.99% = 20% commission
Tier 4 120% to 129.99% = 25% commission
Tier 5 above 130% = 30% commission

Assume sales person A was given a target of $10,000 and he achieved $15,000. How can I use excel formula to help me calculate his commission?

What I am after is to type in the budget and the Auctual and the cell to tell me how much to pay them.

Appreciate your help on this.