Hi all,
Im new to this and hope that someone out there in excel land will be able to help.

we sell a vast range of items that vary in price from a few pence to hundreds of thousands of pounds. I am looking for a sliding scale formula that would help in formulating list prices. The rules would be as follows.

from 0.01 GBP at 100% markup

to 200,000 GBP at 10% markup

Therefore if I am correct a 100,000 GBP item will have a 45% markup (maybe)

Their must be a magic formula that will allow me to type in a cost price of eg. 15,000 GBP and give me a markup from the sliding scale, and then I can calculate the actual markup as a percentage from this.

Help please, and may your formula live long and prosper.

Dougall