#### faphillips

##### New Member

- Joined
- Apr 17, 2010

- Messages
- 15

Hi

I am trying to find a formula to calculate the cost of an item from the selling price and the % margin. For example:

I buy a bottle of wine for £5.50 and sell it in my wine bar for £27.50 which I have calculated as a 400% markup where Price = A1 and Markup =B1 the formula is =A1+(A1*B1)

I now need to find a formula that will find the cost price i.e. £5.50 but only knowing that the sale price was £27.50 and the margin was 400%. It is likely that the margin will always be greater than 100%

I have managed to do this in 2 stages by converting the % figure to a whole number i.e. 400% becomes 4 and adding 1, which equals 5 and then dividing the selling price by 5. There must however be a simpler way of doing this in a formula. Any help would be very much appreciated.

Thank you

Francis

I am trying to find a formula to calculate the cost of an item from the selling price and the % margin. For example:

I buy a bottle of wine for £5.50 and sell it in my wine bar for £27.50 which I have calculated as a 400% markup where Price = A1 and Markup =B1 the formula is =A1+(A1*B1)

I now need to find a formula that will find the cost price i.e. £5.50 but only knowing that the sale price was £27.50 and the margin was 400%. It is likely that the margin will always be greater than 100%

I have managed to do this in 2 stages by converting the % figure to a whole number i.e. 400% becomes 4 and adding 1, which equals 5 and then dividing the selling price by 5. There must however be a simpler way of doing this in a formula. Any help would be very much appreciated.

Thank you

Francis

Last edited: