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?
Printable View
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" <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?
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