How to implement variable percentage calculation?

Question

Spreadsheets

How to implement the calculation of a variable percentage of a number in Spreadsheets or Excel.
Essence of the question:
there is a plate with numbers with an accuracy of 2 decimal places

on the second page of the same document should be displayed in the appropriate cells:
number + percentage (the percentage value depends on the value of the number)
For example
, for a number in the range 0-100, add 100% and round up to nearest integer multiple of 5
for a number in the range of 100-150 add 80% and round up to the nearest integer multiple of 5
for a number in the range of 150-250 add 60% and round to the nearest integer multiple of 5
for a number in the range of 250-400 add 50% and round to the nearest integer multiple of 5
for a number in the range 400-500 add 40% and round to the nearest integer multiple of 5
for a number in the range 500-600 add 30% and round to the nearest integer multiple of 5
for a number in the range 600-800 add 25% and round to the nearest integer multiple 5
for a number in the range of 800-1200, add 20% and round to the nearest integer multiple 5
for a number in the range of 1200-2000, add 15% and round to the nearest integer multiple of 5
, for a number in the range of 2000-3000, add 12% and round to the nearest integer multiple of 5
for a number in the range of 3000-5000 add 10% and round to the nearest integer multiple of 5
for a number in the range of 5000-10000 add 7% and round to the nearest integer multiple of 5
for numbers over 10,000, add 5% and round up to the nearest integer multiple of 5
The task is not easy. Help, who knows how to implement, please.

Answer 1

I am not familiar with Excel, so I can only suggest a partial solution from which you can build.
Create a table with 3 columns

0, 100, 100
100, 150, 80
150, 250, 60
...

Then, using scripting tools (write it yourself), scan raw data cells according to predefined allowances from the table above.