Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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" wrote in message ... 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to determine selling price with cost known @ X margin? | Excel Worksheet Functions | |||
Calculate the percentage from the cost and recommended sell price | New Users to Excel | |||
find selling price of bonds | Excel Worksheet Functions | |||
looking for latest selling price.. | Excel Worksheet Functions | |||
LOOK FOR LATEST SELLING PRICE | Excel Worksheet Functions |