How to calculate the percentage incrementally, depending on the threshold value?

Question

Google Sheets

Please tell me how to write a formula so that when entering a value, the percentage is calculated according to the example:
up to 1 million - 1%,
up to 2 million - 2%,
3 million or more - 3%

i.e. from when entering 1,500,000
the first 1,000,000 - 1% is 10,000
the next 500,000 - 2% is 10,000
Total: from 1,500,000 = 20,000

Answer 1

the OSTAT formula will help you (MOD)