Forum Home
Press F1
 
Thread ID: 111895 2010-08-16 03:20:00 TradeMe Success Fees formula for Excel Chilling_Silence (9) Press F1
Post ID Timestamp Content User
1128234 2010-08-16 03:20:00 I've got a mate I'm helping out who's wanting to keep track of a few auctions he's running, helping out a local non-profit group by selling some items for them on TradeMe.

Long story short, he's wanting a way to figure out what the TradeMe success fees will be in an Excel Spreadsheet.

Having a look here:
www.trademe.co.nz

There's no easy "formula" I can think of that would work, as it really depends on the sell-price value.

Is there any Excel guru out there who may be able to help?

Thanks


Chill. 		Chilling_Silence (9)
1128235 2010-08-16 03:51:00 There is a success fee calc there, is there some reason he can't use that? Deimos (5715)
1128236 2010-08-16 04:27:00 This is a rough cut at an Excel spreadsheet:

Leave cell A1 empty for the example sell price
in cell b2 =IF(A1<7.25,0.5,0)
in cell b3 =IF(AND(A1<150.001, A1>7.24),A1*0.069,0)
in cell b4 =IF(AND(A1>150, A1<1500.001),(10.35+(A1-150)*0.045),0)
in cell b5 =IF(A1>1500,((A1-1500)*0.019)+71.1,0)
in cell a6 =SUM(B2:B5)
Then enter your sell price in A1 and the fee will be shown in A6.
With a bit more work this could be made to work on a whole column of sell prices. 		coldot (6847)
1128237 2010-08-16 04:28:00 Yeah there's this:
www.trademe.co.nz

But we want it all in a nice easy Excel spreadsheet so that at the end he knows exactly how much he's gone and put into the whole thing in terms of a donation through Success Fees and things... 		Chilling_Silence (9)
1128238 2010-08-16 04:55:00 Thanks, I'll give that a try. Chilling_Silence (9)
1128239 2010-08-16 05:00:00 Hey wow that seems to work!!! :D
Is there a way to set the "ceiling" limit, to $149? 		Chilling_Silence (9)
1128240 2010-08-16 05:05:00 Ceiling on what? $5600 as a sell price would equate with a $149 fee. coldot (6847)
1128241 2010-08-16 05:14:00 Ceiling on A6 so that it won't go over $149, even if the item sold is for $6,000.
It's kind of redundant coz I know that they won't be selling anything near that value (I don't think at least), but I'm curious for the sake of completeness :D

Appreciate your help, very much!

Thanks


Chill. 		Chilling_Silence (9)
1128242 2010-08-16 06:27:00 Sorry, I hadn't noticed the $149 absolute maximum.
Replace A6 with:

=IF(SUM(B2:B5)>149,149,SUM(B2:B5))

And sorry about the delay. I went out for my walk and stopped to chat along the way! 		coldot (6847)
1128243 2010-08-16 10:03:00 or you could use =MAX(0.5,MIN(149,SUM(B2:B5))

...or if you want the whole shebang in 1 cell:


=MIN(149,MAX(0.5,IF(A1<150,A1*0.069,IF(A1>1500,71.1+0.019*(A1-1500),10.35+0.045*(A1-150))))) 		MushHead (10626)
1 2