John McGimpsey show how to calculate a variable rate.

May be something you could use.

http://www.mcgimpsey.com/excel/variablerate.html


Gord Dibben MS Excel MVP

On Wed, 27 Aug 2008 12:18:55 -0700, "Ed" wrote:

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.