Ebay fee formula

Hello, Ebay calculate fees on products sold by using the following :

5.25% of the initial £29.99 (£1.57) + 3% of the remaining balance of the
final selling price

Most of the products I sell at more than £29.99, so can anyone help me
express the above as a fomula, asuming that I put the intial price in cell A1
and the final selling price in cell A2?

Thank you very much.

How would you do it with a calculator

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"spudsnruf" wrote in message
...
Hello, Ebay calculate fees on products sold by using the following :

5.25% of the initial £29.99 (£1.57) + 3% of the remaining balance of
the
final selling price

Most of the products I sell at more than £29.99, so can anyone help me
express the above as a fomula, asuming that I put the intial price in cell
A1
and the final selling price in cell A2?

Thank you very much.

On Thu, 12 Nov 2009 14:55:02 -0800, spudsnruf
wrote:

Hello, Ebay calculate fees on products sold by using the following :

5.25% of the initial £29.99 (£1.57) + 3% of the remaining balance of the
final selling price

Most of the products I sell at more than £29.99, so can anyone help me
express the above as a fomula, asuming that I put the intial price in cell A1
and the final selling price in cell A2?

Thank you very much.

I used to use a VLOOKUP table, then I switched to


=ROUND(MIN(E5*1,75)*0.0525+(MIN(925,MAX(E5-75,0)))*0.0275+MAX(E5-1000,0)*0.015,2)

which is what I currently use (copied/pasted from my fee reconciler).

E5 is the final value of course. Note the 75 and 925 relate to Aussie
dollars - your 30 pound threshold and the (presumed 2500?) next
breakpoint less the 30 quid. Adjust as required for any incorrect
assumptions about the breakpoints in your currency.