I want to create a spreadsheet that will allow me to put in the price of an item on my two favorite online marketplaces and see what the actual cost will be to me on them. The issue is that they both have tiered pricing (that is that you pay the percentage on the amounts as you ramp up).
On site one the pricing is as follows:
8%+1c for items 0.01c to $49.99
5.5% for items $50.00 to $999.99
1.5% for items $1,000 and up.
On ebay the pricing is as follows (for items in the Other category):
12% for items 0.99 to $50.00
6% for items $50.01 to $1,000.00
2% for items $1,000.01 and up.
So, remember, the hard part is that an item selling for $100 would cost me 12% for the first $50 and then 6% for the last $50.
I see Column A having the price and Column B having the first site's fees with Column C being ebay's fees. I'll actually create several other columns for ebay's other pricing (different categories and top rated seller discounts) but the core of it needs a formula to deal with the above tiering which I don't know how to provide for in Excel. What I need to understand is what the two formulas for column B and C would look like.
Thanks.
On site one the pricing is as follows:
8%+1c for items 0.01c to $49.99
5.5% for items $50.00 to $999.99
1.5% for items $1,000 and up.
On ebay the pricing is as follows (for items in the Other category):
12% for items 0.99 to $50.00
6% for items $50.01 to $1,000.00
2% for items $1,000.01 and up.
So, remember, the hard part is that an item selling for $100 would cost me 12% for the first $50 and then 6% for the last $50.
I see Column A having the price and Column B having the first site's fees with Column C being ebay's fees. I'll actually create several other columns for ebay's other pricing (different categories and top rated seller discounts) but the core of it needs a formula to deal with the above tiering which I don't know how to provide for in Excel. What I need to understand is what the two formulas for column B and C would look like.
Thanks.
Last edited:
