Calculate the percentage from the cost and recommended sell price
 

Hi,
In Excel example. The cost price is 20.00 and the recommended sell price is
30.00. What is the formulae to calculate the percentage markup of the
recomended sell price?

Calculate the percentage from the cost and recommended sell price
 

A1= 20
B1=30
=(B1-A1)/A1 normal markup as percentage of cost price
or =(B1-A1)/B1 markup as percentage of retail price
formatted as percentage

--
Greetings from New Zealand
Bill K

"John" wrote in message
...
Hi,
In Excel example. The cost price is 20.00 and the recommended sell price
is
30.00. What is the formulae to calculate the percentage markup of the
recomended sell price?

Calculate the percentage from the cost and recommended sell pr
 

the second one is also known as margin
--
paul
remove nospam for email addy!



"Bill Kuunders" wrote:

A1= 20
B1=30
=(B1-A1)/A1 normal markup as percentage of cost price
or =(B1-A1)/B1 markup as percentage of retail price
formatted as percentage

--
Greetings from New Zealand
Bill K

"John" wrote in message
...
Hi,
In Excel example. The cost price is 20.00 and the recommended sell price
is
30.00. What is the formulae to calculate the percentage markup of the
recomended sell price?

Calculate the percentage from the cost and recommended sell pr
 

Thanks Bill,
I´m sorted now
Greetings from Tenerife

"Bill Kuunders" wrote:

A1= 20
B1=30
=(B1-A1)/A1 normal markup as percentage of cost price
or =(B1-A1)/B1 markup as percentage of retail price
formatted as percentage

--
Greetings from New Zealand
Bill K

"John" wrote in message
...
Hi,
In Excel example. The cost price is 20.00 and the recommended sell price
is
30.00. What is the formulae to calculate the percentage markup of the
recomended sell price?

Calculate the percentage from the cost and recommended sell pr
 

Thank you Paul,
I am sorted out now.
greetings from Tenerife

"paul" wrote:

the second one is also known as margin
--
paul
remove nospam for email addy!



"Bill Kuunders" wrote:

A1= 20
B1=30
=(B1-A1)/A1 normal markup as percentage of cost price
or =(B1-A1)/B1 markup as percentage of retail price
formatted as percentage

--
Greetings from New Zealand
Bill K

"John" wrote in message
...
Hi,
In Excel example. The cost price is 20.00 and the recommended sell price
is
30.00. What is the formulae to calculate the percentage markup of the
recomended sell price?

Calculate the percentage from the cost and recommended sell price
 

Be very careful not to confuse mark up with profit. Many a business has
failed because of the lack of understanding between these to numbers.

Marc


"John" wrote in message
...
Hi,
In Excel example. The cost price is 20.00 and the recommended sell price
is
30.00. What is the formulae to calculate the percentage markup of the
recomended sell price?