+ Reply to Thread
Results 1 to 5 of 5

eBay Calculator Formula Help

  1. #1
    Registered User
    Join Date
    02-27-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    6

    eBay Calculator Formula Help

    Hi there

    I am trying to create a formula that will give the total of the eBay fees based on the sale price.

    The fees are as follows. 11% of the selling price if the item is below $50, or if the selling price is $50 or above they charge the 11% up to 50% ($5.50) and then 6% of the remainder.

    I have the sellling price in one column - P3, and I can do seperate formulas for each of the above, however I need to create one formula so it automatically recognises if the selling price is less than or greater than $50 and works out the fees that will be charged.

    I hope that makes sense and any help would be appreciated.

    Thanks
    Phil

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,817

    Re: eBay Calculator Formula Help

    Not sure if I've understood the breakpoints correctly.

    If this isn't correct,please provide examples of payment and the interest you would expect to pay.

    For example, $10, $25, $49, $50, $60, $100.


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-27-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: eBay Calculator Formula Help

    Hi there

    Thanks for the reply.

    For example.

    If I sell an item for $40 - ebay will change me a straight 11% as it is under $50 = $4.40

    If I sell an item for $90 - ebay will change me 11% of the total up to $50 ($5.50) and then 6% of the remaining $40 ($2.40). Total fees in this case would be $5.50+$2.40 = $7.90

    I want to be able to enter just the sell price in a cell and a formula will calculate the fee.

    Thanks
    Phil

  4. #4
    Registered User
    Join Date
    11-23-2011
    Location
    Hurst, Tx
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: eBay Calculator Formula Help

    See if this works for you.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-27-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: eBay Calculator Formula Help

    Fantastic! Thanks for your quick help. That does the trick.

    Phil

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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