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.
|