«
»

Excel Formula for Calculating eBay Listing and Final Value Fees

Excel is very much the battle axe of the information age. White shirted warriors slog it out across the battle field of cells and pivot tables.

Anyway I am getting overexcited.  Here is formulas for calculating eBay final value and listing fees

Listing fee

=IF(D3<0.99, 0.1, IF(D3<4.99,0.15,IF(D3<14.99,0.25,IF(D3<29.99,0.5,
IF(D3<99.99,1.30)))))/E3

Where D3 is the eBay starting or fixed price and E3 is the sell through rate. 

Final Value fee

=IF(D3<29.99, D3*0.075, IF(D3<599.99, 2.24+(D3-29.99)
*0.045,2.24+25.65+ (D3-599.99)*0.019))

Where again D3 is the eBay final price, be it auction or fixed price

If you found this post useful, why not buy me a coffee!

Share and Enjoy:
  • Digg
  • del.icio.us
  • StumbleUpon
  • Technorati

This entry was posted on Tuesday, May 6th, 2008 at 7:03 pm and is filed under eBay. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

  • There appear to be a few errors in that formula, but it may just be my brain. There need to be more brackets isolating the previous tierd fee from being included in the next percentage multiplication, and there appears to be an IF staement missing from the end tier.
  • amin
    great stuff, but what is e3 (sell through rate) i dont get it.
blog comments powered by Disqus