Spreadsheet Formulas

css navigation by Css3Menu.com

eBay Commissions

Rather convoluted but, IF the number is less than or equal to 25, then .0525 times E5, else If E5>1000 then E5 minus 1000.01 times the lookup value plus 1.31 plus 26.81, else E5 minus 25 times the lookup value plus 1.31
=IF(E5<=25,VLOOKUP(E5,A2:C4,3)*E5,IF(E5>1000,(E5-1000.01)*VLOOKUP(E5,A2:C4,3)+1.31+26.81,(E5-25*VLOOKUP(E5,A2:C4,3)+1.31)))

Multiple Item Fixed Price Listings

The Final Value Fee is calculated per item sold, based on the final sale price of the item.

I wrote the formula for one person, verify with eBay befopre accepting as exact.


© 2003-2024

Updated:  01/23/2024 13:34
This page added:  05 August 2003