TechArena Community How to create Margin/markup formula for Excel

# How to create Margin/markup formula for Excel

## Windows Software

#1
06-01-2012
 Member Join Date: Dec 2011 Posts: 59
How to create Margin/markup formula for Excel

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?

#2
06-01-2012
 Member Join Date: May 2011 Posts: 504
Re: How to create Margin/markup formula for Excel

According to my information you should try this:
Quote:
 profit =(Sale Price/Cost Price) -1
#3
06-01-2012
 Member Join Date: May 2011 Posts: 412
Re: How to create Margin/markup formula for Excel

There are two different measurements here that can be used for this Margin/markup formula.
• Markup: =SP/CP %
• Margin: =(SP-CP)/CP %
#4
06-01-2012
 Member Join Date: Jun 2011 Posts: 758
Re: How to create Margin/markup formula for Excel

According to my suggestion if we keep Cost in A1 and price in B1
Then following will be the solution
Quote:
 markup =(B1-A1)/A1 or it is =(B1/A1)-1 margin =(B1-A1)/B1 or =1-(A1/B1)