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?

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" <John@discussions.microsoft.com> wrote in message
news:60F31F92-1338-4972-AF64-8A32886F9130@microsoft.com...
> 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?

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" <John@discussions.microsoft.com> wrote in message
> news:60F31F92-1338-4972-AF64-8A32886F9130@microsoft.com...
> > 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?
>
>
>

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" <John@discussions.microsoft.com> wrote in message
> > news:60F31F92-1338-4972-AF64-8A32886F9130@microsoft.com...
> > > 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?
> >
> >
> >

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" <John@discussions.microsoft.com> wrote in message
> news:60F31F92-1338-4972-AF64-8A32886F9130@microsoft.com...
> > 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?
>
>
>

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" <John@discussions.microsoft.com> wrote in message
news:60F31F92-1338-4972-AF64-8A32886F9130@microsoft.com...
> 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?