I am trying to create a formula that can help me speed up the process when calculating markon percentages to supplier price lists.



In Excel, I am looking for a formula to apply a sliding scale price markup percentage. The size of the percentage markup would decrease as cost increases.
The amount of increments varies between how many products each supplier has but can be from 200 - 40,000. If my logic is correct the formula would have to work on an average between lowest and highest cost and a minimum and maximum mark on. I know what i am trying to achieve but my excel skills are not good enough to work it out.
Any help would be gratefully received.

dan

i have also posted here https://www.excelforum.com/excel-gen...p-formula.html
https://www.excelguru.ca/forums/show...against-produc

Attached Files

saample.xlsx (9.8 KB, 12 views)