from 1 to 1000000 = 6%
1000001 to 1500000 = 7%
1500001 to 2000000 = 8%
2000001 to 2500000 = 9%
2500001 to 3000000 = 10%
3000001 to 3500000 = 11%
3500001 to 4000000 = 12%
4000001 to 1000000000000000000000000000 = 12%
i need a formula to calculate the commision shown above in excel