Excel formula question

[Metalface Mark]

Im currently uploading my new web shop (heating), ive never really delved properly into excel before but one obvious way to save me some time is in the discounting of the products.

If I have my list prices in category M, and my discounted prices at 52.5% in category K, what would the formula to do this without me manually working out the price?

Thanks in advance for a very noobish question!

 

[Metalface Mark]

Work what out?

If you have List Price and your Discounted Price what left is there to calculate (discount)?

I have hundreds of products to put in, I dont want to keep having to manually work out the discount on all the future products i have to put in.

I also have to put in in a different cell my cost price so I have three prices for each item.