Margin, RRP and Cost Price Calculation assistance

excel.jpg

Hi I'm trying to work out the margin in column "Q" based on the Ship Price in column "O" and the RRP in Column "S".

So if "O" was £2.58 and the RRP in "S" was £8.99 - how do I calculate the Margin as a % in "Q" and a monetary value in "R"?

(RRP = Recommended Retail Price)

This is driving me mad - maybe its the flu I currently have

Thanks for having a look.

Hi
I seems that the flu also prevented you from reading the forum rules about post titles? Better have a look at that first.
And what is RRP?