Thread: Formulas
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
SiC
 
Posts: n/a
Default Formulas

Hi Richard,

I am guessing a lot of people don't know the difference between markup and
margin. Assuming your cost is in A1 and your margin in B1, your formula for
retail price would be:
=A1/(1-B1)

-Simon

"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,