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

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.