Richard,

This will calculate the retail price based on the margin you input:

A1: Cost
B1: Margin
C1: =A1 + A1*B1

This will give you a price in C1 based on the margin you input. This will be
margin as a function of cost, obviously, not as a function of final retail
price.

Does this suit your needs?


"Richard" wrote:

Hi,

I would to automatically adjust the retail price on an item by inputting the
margin I would like to make on that product. Is there a formula that will let
me do this.


Thank You,