ebay Calculator

[mrpearl11]

I am trying to create a formula that will give the total of the eBay fees based on the sale price based on the 2011 fee structure.

The fees are as follows. 11% of the selling price if the item is below $50, or if the selling price is $50 or above they charge the 11% of the $50 ($5.50) and then 6% of the remainder. The other part of their pricing is that ebay charges a fee based on the total cost of the product and shipping cost yet only gives a 20 discount off the fee on the product price but not on the shipping.

=IF((A5*.8)+B5<50, ((A5*.8)+B5)*0.11, IF((A5*.8)+B5<1000, 5.50+((A5*.8)+B5-50)*0.06, 5.50+60+((A5*.8)+B5-1000)*.02))

Let's say the following:
A5=1200
B5=17.04

If I make A5=68 the formula works.

This formula works if the product and shipping are under $50, it works if the product and shipping are between $50 and $1000 yet the formula generates an answer that is a little high for anything over $1000. I'm not sure what I am doing wrong as I am using the same logic in the third part of the formula 5.50+60+((A5*.8)+B5-1000)*.02) as I am in the first two parts.

Any help would be appreciated.

[Dennis7849]

I do not understand this;
"if the selling price is $50 or above they charge the 11% up to 50% ($5.50) and then 6% of the remainder."

11% up to 50% ($5.50)??????????

[mrpearl11]

Good catch. I corrected it to how it should be.

[mrpearl11]

though i would still love to get help with the last part of my formula.