#### daleholden

##### Board Regular

- Joined
- Sep 22, 2002

- Messages
- 235

I have a product that costs me £100 looking at the table to the right I want to make a profit that fits the table. But the profit is it to include eBay FVF & PayPal Fee. So we are looking at a Chicken & Egg scenario. I need a goal seeker kind of formula that can workout what to charge as an eBay Sale Price but that includes the Total Cost Price eBay FVF and PayPal Fee.

I am sure there is a way around it but cannot see how to do it.

For this PayPal would be 2.9% + 0.20p

Ebay FVF would be 9%

So I am looking for a formula that will work out an eBay Sale Price that gives me £20 profit and works out the C2,D2 and E2 as a total price.

Hope that makes sense.

PS I want to apply this formula to 1000's of entries to fit the table opposite.

See worksheet here