Ebay UK Fee Calculator

[swiftdaniel]

Hi Guys

I was hoping if someone could help me out. I created an <NOBR id=itxt_nobr_1_0 style="FONT-WEIGHT: normal; FONT-SIZE: 100%; COLOR: #2b65b0; FONT-FAMILY: inherit">excel</NOBR> fomula to calculate the ebay FVF's for a store for buy it now using the below fee structure.

Final Value Fee

£0.99 - £49.99
9.9% of the amount of the final selling price up to £49.99

£50.00 - £599.99
9.9% of the initial £49.99 (£4.95), plus 5.9%of the remaining balance of the final selling price

Over £600
9.9% of the initial £49.99 (£4.95), plus 5.9% of the initial £50.00 - £599.99 (£32.45), plus 1.9% of the remaining balance of the final selling price.

The formula goes like this:

=IF(F13<=50,F13*0.099,IF(F13<=600,((F13-50)*0.059)+4.95,((F13-1000)*0.015)+693))

This seems to work correctly.

Could someone please create a similier formula using the below fee struture? because im struggling.

Any help would be much appriated.

£0.99 - £29.99
5.25% of the final selling price, up to £29.99

£30.00 - £99.99
5.25% of the initial £29.99 (£1.57) plus 3.00% of the remaining balance of the final selling price

£100.00 - £199.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 remaining balance of the final selling price

£200.00 - £299.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) plus 2.00% of the remaining balance of the final selling price

£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 balance of the final selling price

£600.00 or more
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 balance of the final selling price



Kind Regards

Dan<!-- google_ad_section_end -->

 

[Andrew Poulsom]

Welcome to the Board.

See if you can adapt the example here:

http://www.mcgimpsey.com/excel/variablerate.html