In Excel, I am looking for a formula to apply a sliding scale price markup
using interpolation.

The size of the percentage markup would decrease as cost increases and would
increase as cost decreases.

I have 200 products and the cost ranges from $1.50 (approx. 60% markup) to
$35.00 (approx. 15% markup)

Avg. cost is $6.00 (50% markup)


Thank you.

Ed.