I need to compute a table, but I am not sure on how to write the formula.
For example,
Sales price: 10Mil
For first 1mil the tiered rate is 1%
The next 1 mil the tiered rate is 0.8%
The next 3 mil the tiered rate is 0.7%
The next 3 mil the tiered rate is 0.6%
Thereafter the tiered rate is...