Rearranging GP = 1-(cost price/selling price) gives

selling price = cost price /(1- GP)

The word 'maths' suggests UK - I got my 'O' level math in 1954!

So please check this with some data

I wonder if I ever visited your Tilbury pub

best wishes from Canada

--

Bernard V Liengme

Microsoft Excel MVP

http://people.stfx.ca/bliengme
remove caps from email

"Tilburyboozer" <(E-Mail Removed)> wrote in message

news:(E-Mail Removed)...

> We have a pub, and we really need to keep a close watch on profit margins.

> I

> have a formula for calculating the GP from nett cost and selling prices [

> which is 1-(cost price/sales price) ] but my maths lessons are nearly 50

> years back, and I can't work out how to calculate the price we need to

> charge

> in order to make the right margins.

>

> A younger memory will solve this in seconds, I know, so please lend a

> hand.