+ Reply to Thread
Results 1 to 6 of 6

Google Sheet Formula - Deduct Custom Fees from Selling Price to generate Payout Price

  1. #1
    Registered User
    Join Date
    04-23-2007
    Posts
    34

    Smile Google Sheet Formula - Deduct Custom Fees from Selling Price to generate Payout Price

    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

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Google Sheet Formula - Deduct Custom Fees from Selling Price to generate Payout Price

    Into C2:
    Please Login or Register  to view this content.
    Into D2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    drag both formulas down.

    Check you file.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    04-23-2007
    Posts
    34

    Re: Google Sheet Formula - Deduct Custom Fees from Selling Price to generate Payout Price

    Hi, thanks so much for the quick reply!

    This is great but I don't think it's adding the Shipping Fee for Website 2.

    See the following example:
    https://snipboard.io/2t58nB.jpg

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Google Sheet Formula - Deduct Custom Fees from Selling Price to generate Payout Price

    It was not, indeed. Check now.

  5. #5
    Registered User
    Join Date
    04-23-2007
    Posts
    34

    Re: Google Sheet Formula - Deduct Custom Fees from Selling Price to generate Payout Price

    Awesome, thanks so much!

  6. #6
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Google Sheet Formula - Deduct Custom Fees from Selling Price to generate Payout Price

    Happy to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula for Selling Price - Cost, only if Sold
    By Kevin.Es in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-07-2018, 11:31 AM
  2. Formula that determines selling price
    By couevans in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-24-2017, 06:16 PM
  3. Expressing Selling Price as a percentage of List Price
    By Antman452 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-02-2016, 08:21 AM
  4. [SOLVED] Setting a selling price based on cost price and order quantity
    By Steven811 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-11-2014, 08:07 AM
  5. Calculating Selling Price Formula in Excel
    By hitari in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-24-2013, 10:07 AM
  6. Replies: 2
    Last Post: 04-13-2012, 08:22 AM
  7. Replies: 5
    Last Post: 02-06-2012, 06:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1