Ebay Calculation Fees in Excel

[esuperbook]

Hi. We are expanding our line of products to ebay and need a way to calculate the fees in excel. My friend and I are currently stumped of what calcultion to use.

Here is an an example of our spreadsheet & fee structure. Make sure you scroll all the way to the right to get the example.

<table class="MsoNormalTable" style="" border="0" cellpadding="0" cellspacing="0"><tbody><tr style=""><td style="border: medium none rgb(236, 233, 216); padding: 0in; background-color: transparent;" valign="top"><o></o>
<o>If anyone can help us solve this problem we'd really appreciate it!</o>
<o></o>
<o>-eSuperBook</o>
</td><td style="border: medium none rgb(236, 233, 216); padding: 0in; background-color: transparent;" valign="top"><v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></vath><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape id="_x0000_i1025" style="width: 0.75pt; height: 0.75pt;" alt="" type="#_x0000_t75"><v:imagedata o:href="http://pics.ebay.com/aw/pics/s.gif" src="file:///C:%5CDOCUME%7E1%5CLMENDI%7E1.USE%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_image001.gif"></v:imagedata></v:shape><o></o>
</td><td style="border: medium none rgb(236, 233, 216); padding: 0in; background-color: transparent;" valign="top"><o></o>
</td></tr></tbody></table>

 

[barry houdini]

I'm not sure which fees you want to calculate.

This will give you the final value fee if sale price is in D2

=IF(D2="","",ROUND(D2*1.5%+MIN(D2,1000)*(3.5%-1.5%)+MIN(D2,25)*(8.75%-3.5%),2))

rounds to the nearest cent

 

[Smitty]

Welcome to the Board!

I deleted your tables because they were blowing up the page. Follow this link to Colo's HTML Maker, which will let you post shots of your sheet(s).

It'll be a lot easier to get you what you need then, although I suppose Barry already has.

 

[esuperbook]

Thanks for the help!