Microsoft Office Forums Excel eBay Fee Calculator Formula
 Register FAQ Search Today's Posts Mark Forums Read

#1
09-10-2012, 10:03 AM
 rdonovan1 Windows 7 64bit Office 2010 64bit Novice Join Date: Sep 2012 Posts: 5
Excel eBay Fee Calculator Formula

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.
#2
09-10-2012, 07:37 PM
 macropod Windows 7 64bit Office 2010 32bit Administrator Join Date: Dec 2010 Location: Canberra, Australia Posts: 21,506

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
(and who knows how many others)

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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Last edited by macropod; 09-12-2012 at 02:44 AM. Reason: Yet another cross-post found!!

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post djreyrey Excel 8 04-15-2011 03:55 PM Mandusin Excel 6 12-25-2010 07:34 AM turns Outlook 0 06-15-2010 12:26 AM sellspeed Excel 15 03-10-2010 10:57 AM masoom84 Excel 1 03-07-2009 09:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top