Hi
On a smiliar note I've been trying to amend your formula for Ebay UK, but I
just can't do it. Please help:

The fee structure on Ebay UK is more complex than it's American counterpart.
It is as follows:

Item not sold - None

£0.01- £29.99 - 5.25%

£30.00 - £99.99 - 5.25% of the initial £29.99 (£1.57) plus 3.00% of the
remaining closing value

£100.00 - £199.00 - 5.25% of the initial £29.99 (£1.57) plus 3.00% of the
initial £30.00 - £99.99 (£2.10) plus 2.50% of the remaining closing balance

£200.00 - £299.00 - 5.25% of the initial £29.99 (£1.57), plus 3.00% of the
initial £30.00 - £99.99 (£2.10), plus 2.50% of the initial £100.00 - £199.99
(£2.50) plus 2.00% of the remaining closing value balance

£300.00 - £599.99 - 5.25% of the initial £29.99 (£1.57), plus 3.00% of the
initial £30.00 - £99.99 (£2.10), plus 2.50% of the initial £100.00 - £199.99
(£2.50) 2.00% of the initial £200.00 - £299.99 (£2.00) plus 1.50% of the
remaining closing value balance

£600.00 and over - 5.25% of the initial £29.99 (£1.57), plus 3.00% of the
initial £30.00 - £99.99 (£2.10), plus 2.50% of the initial £100.00 - £199.99
(£2.50) plus 2.00% of the initial £200.00 - £299.99 (£2.00) plus 1.50% of the
initial £300.00 - £599.99 (£4.50) plus 1.00% of the remaining closing value
balance

I amended your formula as follows but it doesn't generate the correct figu

=MIN(A1,29.99)*5.25%+MIN(70,MAX(A1-29.99,0))*3%+MIN(99.01,MAX(A1-99.99,0))*2.5%+MIN(99.01,MAX(A1-199.99,0))*2.5%+MIN(100,MAX(A1-299.99,0))*2%+MIN(300,MAX(A1-599.99,0))*1.5%+MAX(A1-600,0)*1%

"Harald Staff" wrote:

"shadrach" skrev i melding
...
That's it. Works good. Thanks!!!

Glad to hear that. Thanks for the feedback.

Best wishe Harald