Figuring Profit Margins - HELP ME!! PLEASE!!!

[lmburns]

I have a "order form worksheet" set up in excel. I have the followin
columns:

Quantity - how many of "item"
Retail Price - the listed retail price of "item"
Cost Price - what "item" costs me
Sale Price - what I charge customer for "item"
Profit - difference between Cost & Sale price

I need to add a column that shows the Profit Margin in percentage.
What formula do I use?

Can anyone help me with this???

 

[George Nicholson]

Profit/Cost

so, if your profit is 1/2 of what it cost, your profit margin is 50%

 

[Fred Smith]

In the terminology I am used to, margin = profit / sale price. Format this
as a percentage. This will then show your profit as a percentage of the sale
amount. I hope this is what you want.