If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Ebay fee formula
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. |
#3
|
|||
|
|||
Ebay fee formula
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. |
Thread Tools | |
Display Modes | |
|
|