ExcelBanter - Formula for calulating percentage

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula for calulating percentage (https://www.excelbanter.com/excel-programming/448207-formula-calulating-percentage.html)

Sabir

Formula for calulating percentage

i have values 0-5000
i want to add percentage to the value as follows
less than 100 - 25%
100-300 -20%
300-400 -15%
400-500 -10%
500-600 -8%
600-900 -7%
above 900 -6%

can anyone help me to put a formula to calculate this.please!!!

All times are GMT +1. The time now is 07:52 PM.