Hi all,
I think this is more of a math problem than an excel problem, but I am hoping there is a function that could help.
I am trying to workout prices for our website. The price is made up of the item cost, the profit % required and VAT where applicable. This then gives the sell price.
However we are charged 3.9% + 20p for every transaction through paypal.
I would like to include this in the final sale price, but because it is based on the final sale price, its not that easy.
for instance £100 sale price x by 103.9%+20p = £104.1 now if paypal deduct their fee it works like this £104.1 x 3.9% +20p = £4.25 - from our £104.1 = £99.84 not £100.
Any help would be greatly appreciated.
Thanks
Kieren
Bookmarks