Thank you so much for your help.
Ed.
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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.