ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Ising Formula (https://www.excelbanter.com/excel-programming/378595-ising-formula.html)

D. Vaughn

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


somethinglikeant

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