Excel eBay Fee Calculator Formula

[rdonovan1]

How do I create a formula in Microsoft Excel 2010 that will take a monetary amount like a price from a cel, calculate the first $50 dollars at 11% and then take the remaining amount between $50.01 to $1,000.00 and calculate that at the rate of 6% and then take both answers, add them together and return them to a cell.

I have been trying to figure out how to get Excel to do this, but so far have had no luck at all. If anyone can tell me how to create a formula that will do this and can even given me some examples I'd appreciate it.

 

[RoryA]

Please note that I have removed all the posts that did not relate to the question at hand.

@rdonovan1,

First off, welcome to the forum.
We are genuinely glad to have you here and I hope you have received satisfactory answers to your question.

Now, a little clarification regarding the dialogue that went on here:

Nobody was suggesting that you cannot post in multiple forums, however it is courteous (as well as a forum rule) to provide links to your cross-posts so that posters do not spend time duplicating suggestions already made elsewhere or replying to questions that have already been solved. The suggested article here explains the etiquette very well, as well as the reasons behind it.

Thank you.

 

[PaddyD]

I would also draw everyone's attention to rule 16 about 'back seat moderation'. If people think forum rules are being broken, the best / preferred / required approach is alert one of the moderating team and let us take care of it. This thread is an example of what happens when its kept in public.

 

[rdonovan1]

Please note that I have removed all the posts that did not relate to the question at hand.

@rdonovan1,

First off, welcome to the forum.
We are genuinely glad to have you here and I hope you have received satisfactory answers to your question.

Now, a little clarification regarding the dialogue that went on here:

Nobody was suggesting that you cannot post in multiple forums, however it is courteous (as well as a forum rule) to provide links to your cross-posts so that posters do not spend time duplicating suggestions already made elsewhere or replying to questions that have already been solved. The suggested article here explains the etiquette very well, as well as the reasons behind it.

Thank you.

That I can do and will keep that in mind for future reference.