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" <[email protected]> wrote in message
news:[email protected]...
> 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?

Thank You Peo Sjoblom