Hello,

I am having a lot of trouble trying to figure out a way to create a
spreadsheet to automate my retail markup process. Here is what I am
trying to do:

Let's say for items costing me $1.00 I would like to have a 500%
markup. A $3.00 item, a 300% markup. By the time an item reaches a cost
of $50.00 I would like the markup to fall to around 100%.

I am guessing this would involve some kind of logarithmic function, I
am not sure.

I would like to have a spreadsheet that allows me to adjust the
properties of this curve by adjusting 1 or 2 cells, changing it's shape
to find one that fits my needs.

I have had some success, but the can never seem to adjust the rate of
decay and its position in the curve as I would like.

Could anyone offer a solution to my problem? It would be most
appreciated.

Best Regards,

Fibonacci