Hi all,

I am trying to get an accurate way of costing our products using a spreadshhet where we can change our required margins for different markets.

The only problem is that we have a Paypal fee on all transactions, so that includes postage and all other costs. What I would like to do is include the cost of the transaction fee into the sale price, so that we are not losing our margin. But when you add 3.9% +0.20p to say £10 it becomes £10.59. then if you apply the transaction fee its £10.59*0.039 +0.2=£0.61 not 0.59.

Any help would be really appreciated. I have been wrapping my brain for days trying to do this.

Thanks
Kieren