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

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.

=((C8-1000.01)*0.02)+((C8-50)*0.05)+(50*0.07)

flipjarg,

Give this a try:

=IF(NOT(ISNUMBER(C8)),0,MIN(C8,50)*0.07+MAX(0,MIN(C8-50,950))*0.05+MAX(0,C8-1000)*0.02)

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

Maybe ...

       -----A----- -----B-----
   1      Gross        Net    
   2       $10.00       $9.30 
   3       $20.00      $18.60 
   4       $50.00      $46.50 
   5      $100.00      $94.00 
   6      $200.00     $189.00 
   7      $500.00     $474.00 
   8    $1,000.00     $949.00 
   9    $2,000.00   $1,929.00 
  10    $5,000.00   $4,869.00

In B2 and down,

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

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.