Hi
I don't know if there is a formula for this? but here's the problem

Let's say I want to give company staff a bonus based on the amount of sales they earn?

If they earn below £5000 of sales in a month, their bonus would be 5%, if they earn between £5000 - £10,000 of sales in a month then they would receive 10% and 15% for anything above, so need the percentage to change once the value reaches each threshold.

Thanks in advance