![]() |
Ising Formula
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 |
Ising Formula
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 |
All times are GMT +1. The time now is 09:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com