software

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?

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

quot;Johnquot; gt; wrote in message
...
gt; Hi,
gt; In Excel example. The cost price is 20.00 and the recommended sell price
gt; is
gt; 30.00. What is the formulae to calculate the percentage markup of the
gt; recomended sell price?
the second one is also known as margin
--
paul
remove nospam for email addy!
quot;Bill Kuundersquot; wrote:

gt; A1= 20
gt; B1=30
gt; =(B1-A1)/A1 normal markup as percentage of cost price
gt; or =(B1-A1)/B1 markup as percentage of retail price
gt; formatted as percentage
gt;
gt; --
gt; Greetings from New Zealand
gt; Bill K
gt;
gt; quot;Johnquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; In Excel example. The cost price is 20.00 and the recommended sell price
gt; gt; is
gt; gt; 30.00. What is the formulae to calculate the percentage markup of the
gt; gt; recomended sell price?
gt;
gt;
gt;

Thanks Bill,
I´m sorted now
Greetings from Tenerife

quot;Bill Kuundersquot; wrote:

gt; A1= 20
gt; B1=30
gt; =(B1-A1)/A1 normal markup as percentage of cost price
gt; or =(B1-A1)/B1 markup as percentage of retail price
gt; formatted as percentage
gt;
gt; --
gt; Greetings from New Zealand
gt; Bill K
gt;
gt; quot;Johnquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; In Excel example. The cost price is 20.00 and the recommended sell price
gt; gt; is
gt; gt; 30.00. What is the formulae to calculate the percentage markup of the
gt; gt; recomended sell price?
gt;
gt;
gt;

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

quot;paulquot; wrote:

gt; the second one is also known as margin
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Bill Kuundersquot; wrote:
gt;
gt; gt; A1= 20
gt; gt; B1=30
gt; gt; =(B1-A1)/A1 normal markup as percentage of cost price
gt; gt; or =(B1-A1)/B1 markup as percentage of retail price
gt; gt; formatted as percentage
gt; gt;
gt; gt; --
gt; gt; Greetings from New Zealand
gt; gt; Bill K
gt; gt;
gt; gt; quot;Johnquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi,
gt; gt; gt; In Excel example. The cost price is 20.00 and the recommended sell price
gt; gt; gt; is
gt; gt; gt; 30.00. What is the formulae to calculate the percentage markup of the
gt; gt; gt; recomended sell price?
gt; gt;
gt; gt;
gt; gt;

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.

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