Hello everyone
I am selling some items on different websites - and each website has their own fee system.
I have a Fees worksheet where I set the fees per website.
I also have a Sales worksheet where I log my sales.
I would like the Sales worksheet to automatically deduct the 'Fees' from the 'Selling Price' to generate the 'Payout' price - and these fees of course should be linked to the selected website.
Working example for a Website 1 sale:
Selling Price is:
£205.00
10% Transaction Fee is:
£20.50
3% Payment Fee is:
£6.15
Total Payout should be:
£178.35
Public sheet is here:
https://docs.google.com/spreadsheets...it?usp=sharing
Thanks in advance for any help
Bookmarks