Math mavens, a little help. Pricing formula.

Factual Questions
1

In a nutshell I am looking for a formula suitable for excel that will do the following

It is for doing retail parts markup from wholesale. I need a formula for calculating a smoothly adjusting parts markup curve from 400% @ $1 wholesale to 5% at $2500 wholesale so there are no dramatic shifts in the pricing structure while keeping a competitive top end. As nice as it might be to use a flat markup, at the high end, I find its generally not competitive and would like to find a semi simple silding scale.

So a $1 should be $5, a $2500 item would cost $2625. I want to be able to apply a single formula to get this.

Any help would be appreciated.

2

You’re going to have to be a bit more detailed about what sort of curve you want. Concave, or convex? Fast rising, or slow rising?

3

Should drop pretty quick, say around 100% at $10 or so down to about 20% at $200. I am not familiar with a convex or concave curve wrt this appllication.

4

Try this one. It’s ugly but I think it matches the info you’ve given us decently:

=IF(C3<=1,4,IF(C3>=2437,5%,3.9767*C3^(-0.5609)))

Where in my case, C3 was the cell containing the cost

5

OK cool, that pretty much fits the bill. I’m sure I can tinker with it a bit from here TYVM