How to create Margin/markup formula for Excel

[Lanka Boy]

Hi friends recently I 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?

[Bontu]

According to my information you should try this:

profit =(Sale Price/Cost Price) -1

May this will help you out.

[Essien]

There are two different measurements here that can be used for this Margin/markup formula.

• Markup: =SP/CP %
• Margin: =(SP-CP)/CP %

[DanielaA]

According to my suggestion if we keep Cost in A1 and price in B1
Then following will be the solution

markup =(B1-A1)/A1 or it is =(B1/A1)-1
margin =(B1-A1)/B1 or =1-(A1/B1)