# Margin/markup formula for Excel

• 01-03-2005, 01:23 PM
Wardo
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?
• 01-03-2005, 02:06 PM
JethroUK&copy;
Re: Margin/markup formula for Excel
profit =(Sale Price/Cost Price) -1

"Wardo" <Wardo@discussions.microsoft.com> wrote in message
news:F81F31F1-B52F-4A28-BF3A-13A5E92B6880@microsoft.com...
> 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?

• 01-03-2005, 02:06 PM
Gordon
Re: Margin/markup formula for Excel
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 %
• 01-03-2005, 02:06 PM
Peo Sjoblom
RE: Margin/markup formula for Excel
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?

• 09-19-2009, 06:52 PM
SuthoShark
Re: Margin/markup formula for Excel
Thank You Peo Sjoblom