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, 10 views)

Links added by OP

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Just wondering why you need to cross post here after you have had lots of help on EF?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post