View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bill Kuunders
 
Posts: n/a
Default 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?