| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
