[elitegimp]

[ QUOTE ]
I want to know the math used to calculate mark up%. I am talking about the mark up % used by retailers to price goods for sale. The reason I want to know is so I can put the formula into a excel spreadsheet.

I want to be able to enter any two of the following. The cost amount, MU%, or selling price and be able to calculate the missing one. So I think I need 3 formulas.

I don't think I explained this very well. Sorry for the dumb question but it would be a great help if I could get it answered.

[/ QUOTE ]

I think these are the formulas you want:

Markup Percent = 100*(Price/Cost - 1) [100 = 100%]
Price = Cost*(1+Markup Percent/100)
Cost = Price / (1+ Markup Percent/100)

Examples:
* An object costs the store $5, they sell it for 6. The markup is 100*(6/5-1) = 100*(0.2) = 20 (as in 20% markup)
* An object costs the store $5, they mark it up 20%. Then the price is $5*(1+20/100) = $5*1.2 = $6.
* An object sells for $6 and is known to be marked up 20%. Then it originally cost the store $6/(1+20/100) = $6/1.2 = $5

Or this might not be what you asked at all [img]/images/graemlins/smile.gif[/img]