Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 09-10-2012, 10:03 AM
rdonovan1 rdonovan1 is offline Excel eBay Fee Calculator Formula Windows 7 64bit Excel eBay Fee Calculator Formula Office 2010 64bit
Novice
Excel eBay Fee Calculator Formula
 
Join Date: Sep 2012
Posts: 5
rdonovan1 is on a distinguished road
Default 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  
Old 09-10-2012, 07:37 PM
macropod's Avatar
macropod macropod is offline Excel eBay Fee Calculator Formula Windows 7 64bit Excel eBay Fee Calculator Formula Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel eBay Fee Calculator Formula ** Excel Formula djreyrey Excel 8 04-15-2011 03:55 PM
Excel Calculator Mandusin Excel 6 12-25-2010 07:34 AM
Age Calculator in MS Outlook 2002 SP3 turns Outlook 0 06-15-2010 12:26 AM
excel help Formula sellspeed Excel 15 03-10-2010 10:57 AM
Excel Formula Help masoom84 Excel 1 03-07-2009 09:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft