margin calc

  • Thread starter Thread starter Steve Davey
  • Start date Start date
S

Steve Davey

Can anybody tell me the best formula to use to calculate the profit margin
between two number when this maybe plus or minus
 
Steve

I use

=1-(Buy/Sell)

You could use

=(Sell-Buy)/Sell

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

weighted average profit margin 4
Need assistance with an extended formula 2
I think I need a match, vlookup, or index function? 1
Pivot Table Help - Gross Margin % & % of Sales 2
Pivot Table Help - Gross Margin % & % of Sales 1
Excel Assistance with Fomula 0
Gross margin 4
Help with what should be a simple formula.. 2

Back
Top