need help with creating a sheet to calculate sales price

Hi all
I currently sell online on ebay, and want to calculate what price to sell at based on a margin that i want to make e.g. 10%
The tricky part is that to calculate the profit margin it relies on on a cell which calculates the ebay and paypal fee.

i.e. i want the spreadsheet to work out the price to sell an item for, however there is a cell which relies on the sales price.

Is there a way around this?

I have made a sample sheet, however as you can see there seems to be an error.

Will take a few min but yeah.

Im glad to hear its possible.
Could you possible guide me in the right direction please

Page 2 should do it I think, I set it up with Solver, just a quick dirty.

Thanks for that, however i am ideally looking for a solution where by just entering the cost price it will automatically calculate it.

I think its a circular reference issue that i am dealing with.

I have enabled the iterations options, but still no joy.

If you have a look on the sheet i have made, it sometimes work when you change the profit margin to 0%, and if you play around by adding increasing it in small amounts its fine, however try changing it maybe 1000% its starts playing up, it will either give a really high number or just give the NUM! error

Does this give you what you need? Enter your cost, postage and packaging in the yellow cells and then you can change the MarkUp in column E to see how it effects you Net Profit and Net Profit %.

HTH

Tom