Calculating different fees

Hello,

My first post here.

I want to calculate the fee for zoning of a property, and the council operates with this matrix for the fee obove 5 000 sqm. Lets say I have 35 000. What is the most rational way of calculating this?

The fee per sqm is:
5 001 - 15 000 = 1$ per sqm
15 001 - 30 000 = 0.5$ per sqm
30 001 and above = 0.3 per sqm

Thanks in advance, and sorry for not explaining this very rationally, English in my second language.

Thanks for the fast reply!

The problem is that the fees stacks. So the first 5000 sqm costs 10 000$ flat. Then in the interval 5001 - 15 000 costs 1$ per sqm. So if you max that its 9 999$. Then you stack on the 15 001 - 30 000 interval. And so on.

Yes, no problem!

The cost for 3998 sqm would be $10 000, since anything below 5000 sqm is charged with $10 000
The cost for 7885 sqm would be $10 000 (for the first 5000 sqm) + $2885 ((7885-5000) * $1) = $12 885
The cost for 16 280 sqm would be $10 000 (for the first 5000 sqm) + $10 000 ((15 000-5001) * $1) + $640 ((16 280 - 15 000) * $0.5) = $20 640
The cost for 37 700 sqm would be $10 000 (for the first 5000 sqm) + $10 000 ((15 000-5001) * $1) + $7 500 ((30 000 - 15 000) * $0.5) + $2310 ((37 700-30 001)* $0.3 = $29 810

I could of course make a table where every single value between 1sqm and 50 000+ sqm have been calculated and used VLOOKUP, but I find that rather meaningless and very space consuming