Calculating total fees based on different fee brackets (for eBay fees)

**flipjarg** · 06-05-2012, 04:40 PM

Here is what I am trying to calculate. The following are fees for whatever a given total purchase comes to... so it is basically totalPurchase minus the following... this is a free calculator I am trying to build.

7.0% of the initial $50.00, plus 5.0% of the next $50.01–$1,000.00, plus 2.0% of the remaining balance ($1,000.01–total cost to buyer)

This is how I have done it but the middle equation is what I think I have wrong.

Please Login or Register  to view this content.

**tigeravatar** · 06-05-2012, 04:56 PM

flipjarg,

Give this a try:

Please Login or Register  to view this content.

**roki4** · 06-05-2012, 04:56 PM

Check your order of operations, i.e. your bracket placement.

**flipjarg** · 06-05-2012, 06:04 PM

Nice, thanks for the added error checking. Unfortunately, according to eBay's clumsy fee calculator, both of our calculations are off. My original equation brings up about $20 too high and your equation is about $30 too low. As suggested before, I looked at the "order of operations, i.e. your bracket placement" but couldn't find anything I thought was wrong. I am not familiar with the MIN() and MAX() syntax at this time, so maybe I missed something.

I am just going for the straight fees (not including insertion fees) at this time. All of my other calculations are correct except for the price bracket $1000.01 and higher. The calculator: http://pages.ebay.com/sellerinformat...alculator.html

**shg** · 06-05-2012, 06:14 PM

Maybe ...

Please Login or Register  to view this content.

In B2 and down,

=A2 - SUMPRODUCT((A2>{0,50,1000}) * (A2-{0,50,1000}) * {7,-2,-3}%)

**zbor** · 06-06-2012, 02:31 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**flipjarg** · 06-08-2012, 11:28 AM

Okay, it looks like all of these were good options... I was using the wrong percentage in one of my variables. Thank you for the help.. this is now solved, with a lot of good input for anyone else who might need this info in the future! Thank you!