I have a formula I found through Google and want to use it in a spreadsheet.
Here is what I found;

Margin from Cost and Selling Prices
Sometimes you will have a cost and selling price, and need to know what
margin that results in. The formula is :

margin = (1 - (cost/selling))x100

How can I put this formula in a spreadsheet to find the margin between the
cost and selling price of an item?

DonV

In the cell where you want the result to be displayed type

=(1-(A2/B2))*100) assuming A2 is the cell where you have input the
cost, and B2 where you have input the selling price.

Hope this helps

http://www.excel-ant.co.uk