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.

[macropod]

Cross-posted at:
http://www.excelforum.com/excel-form...alculator.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: http://www.excelguru.ca/content.php?184

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.

This thread will now be locked.