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
=IF(D3<0.99, 0.1, IF(D3<4.99,0.15,IF(D3<14.99,0.25,IF(D3<29.99,0.5,
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)
Where again D3 is the eBay final price, be it auction or fixed price