Margin/markup formula for Excel
I am trying to insert a formula to calculate a percentage of margin/markup.
Example cost = $7.00 divided by 30 % = $10.00. My cost is 7.00, my sale price is 10.00. Can anyone help with this formula? |
profit =(Sale Price/Cost Price) -1
"Wardo" wrote in message ... I am trying to insert a formula to calculate a percentage of margin/markup. Example cost = $7.00 divided by 30 % = $10.00. My cost is 7.00, my sale price is 10.00. Can anyone help with this formula? |
Wardo wrote:
I am trying to insert a formula to calculate a percentage of margin/markup. Example cost = $7.00 divided by 30 % = $10.00. My cost is 7.00, my sale price is 10.00. Can anyone help with this formula? There are two different measurements here. Markup: =SP/CP % and Margin: =(SP-CP)/CP % |
Cost in A1, price in B1
markup is =(B1-A1)/A1 or =(B1/A1)-1 margin =(B1-A1)/B1 or =1-(A1/B1) Regards, Peo Sjoblom Regards, Peo Sjoblom "Wardo" wrote: I am trying to insert a formula to calculate a percentage of margin/markup. Example cost = $7.00 divided by 30 % = $10.00. My cost is 7.00, my sale price is 10.00. Can anyone help with this formula? |
All times are GMT +1. The time now is 02:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com