Excel eBay final value fee calculator

**rdonovan1** · 09-10-2012, 02:16 AM

I am trying to write a formula that will take the eBay fixed priced final value fee percentages and will tell me as to how much the total final value fee is going to be, but I'm having problems figuring out how to properly write the formula in Excel.

Most of the stuff that I am looking to sell on eBay at the moment tends to fall into eBay's other category. eBay calculates things in three different tiers. The first tier ranges from $.99 to $50.00. The second tier ranges from $50.01 to $1,000.00. The third tier ranges from $1,000.01 on up.

In the first tier eBay charges 11%. Once an item enter the second tier, they charge 11% on the first $50.00 and then 6% on the remainder in the second tier and 2% on the remainder in the third tier. I've got my spreadsheet working fine with anything in the first tier. The problem that I'm having though is coming up with a formula that will look at the value in the price cell and then will determine, calculate and return the final value fee based on the amount in the price cell.

If the price is for example $54.95 then the formula should calculate it at 11% for the first $50.00. It should then take the remaining amount (in this example $4.95) and calculate that at 6%. It should then take the first amount and add that together with the second amount and return the value along with the $.50 cent fixed price fee that eBay charges.

I've tried to use the If function to calculate this, but I'm probably writing the expression wrong because when I try to write it all I get are error messages instead of the result.

I've scanned through numerous books relating to the subject, but none of them really seem to give me a clear cut solution at all on how to do it and I'm hoping that maybe someone here might happen to know how to create a formula within excel that will do that.

I've done some programming in the past, but I haven't done it in a while and am rusty at it. I know however that in a programming language one could write a routine that would take the variable and would compare it to see if it matched and while I wouldn't mind setting something like that up in something like VBA I'm primarily looking at just creating a formula that will calculate it so that I can find out as to how much the final value fee's will be so that I can add them onto the price so that I can pass that on to the customer. It's a process called markup in the business world and is fairly common. I however am just having problems getting Excel to cooperate with me on the issue without having to resort to programming.

**zbor** · 09-10-2012, 02:26 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.

**rdonovan1** · 09-10-2012, 02:36 AM

I hope that the change that I made to the title corrects the issue with the rule. I'm just not really sure as to what else to call it because this issue is so confusing to me.

It should be relatively easy to create a formula that makes the kinds of calculations that I need it to do, but getting Excel to do it doesn't seem to be an easy thing to do.

**macropod** · 09-10-2012, 10:38 PM

Cross-posted at:
http://www.msofficeforums.com/excel/...r-formula.html
http://www.mrexcel.com/forum/excel-q...r-formula.html
http://www.techsupportforum.com/foru...la-665146.html
http://answers.microsoft.com/en-us/o...6-253aa278d905
(and who knows how many others)
For cross-posting etiquette, please read RULE 8!!!

It is rude to have people in so many forums wasting their time providing essentially the same advice and not letting on about the advice you've already received. Keep it up and see how many you get banned from.

**Richard Buttrey** · 09-12-2012, 12:43 PM

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

@macropod,

Thanks for the notification Paul