Hi,

I have an excel sheet containing products which I sell and I am trying to work out a formula to give me a retail price (selling price) based on a desired profit margin taking into account all costs and fees. My spreadsheet is set out as follows:

Column H - Cost of goods from supplier
Column I - Cost of delivery from supplier
Column J - VAT (20% of column H an I)
Column K - Total Cost (total of H,I and J)
Column L - Postage Credit (credit received from Amazon when selling on their site)
Column M - Fees (variable fees owed to Amazon, 0.13*column L and column N)
Column N - Retail price i.e. price I will sell the item for
Column O - Profit =SUM(N4+L4)-(K4+M4)
Column P - Profit % - This is the column where I wish to enter the desired margin percentage to calculate column N

Any help would be appreciated as this has me beat!

Graham