Excel Formula. Need help...complicated.

**gamerman0203** · 05-22-2006, 08:43 AM

Hello everyone! I rarely use Excel so I only know how to do basic formulas. Can someone help me make a formula that reflects this data:

first $500 @ 8%
next $1,000 @ 1.5%
next $5,000 @ 1%
next $20,000 @ .25%
over $26,501 @ .1%
+ $5 to total.

I need this to work for any amount so Excel will calculate the end result for me. The formula will draw a number out of a single cell to apply to.

It commission that I earn off of ebay sales for my company.

Any help will be greatly appreciated!!! Thank you!

Anne Troy · 05-22-2006, 08:27 PM

Hi, Gamerman. I once asked MrExcel how to do this because I didn't know how either. While I didn't test his directions, no one has told me they don't work. I took what he gave me and turned it into an article. See:
http://www.officearticles.com/excel/...soft_excel.htm

Bill calls them "Tiered Commissions"

dheerajnagpal · 05-23-2006, 02:53 AM

Hi Gamerman,

I used something similar for calculating income tax with different slabs.
Am attaching the sheet here for your reference. You will need to add more rows and drag the formula and it should work.

Hopefully that is what u required. Do let me know in case you need some changes or clarifications.

Cheers
Dheeraj

**gamerman0203** · 05-23-2006, 07:55 AM

thanks fella's! I'll give em a shot! Much abliged!

05-22-2006, 08:43 AM	#1 (permalink)
gamerman0203 Retired Join Date: Oct 2005 Location: Grand Rapids, MI Posts: 2,144 OS: XP MCE, Ubuntu Gutsy My System	Excel Formula. Need help...complicated. Hello everyone! I rarely use Excel so I only know how to do basic formulas. Can someone help me make a formula that reflects this data: first $500 @ 8% next $1,000 @ 1.5% next $5,000 @ 1% next $20,000 @ .25% over $26,501 @ .1% + $5 to total. I need this to work for any amount so Excel will calculate the end result for me. The formula will draw a number out of a single cell to apply to. It commission that I earn off of ebay sales for my company. Any help will be greatly appreciated!!! Thank you! __________________ Follow These Steps First! CPU-Z \| SensorView \| WinXP Clean Boot \| Latest DirectX \| ATI Catalyst \| Nvidia ForceWare Posting System Specifications

05-23-2006, 07:55 AM	#4 (permalink)
gamerman0203 Retired Join Date: Oct 2005 Location: Grand Rapids, MI Posts: 2,144 OS: XP MCE, Ubuntu Gutsy My System	thanks fella's! I'll give em a shot! Much abliged! __________________ Follow These Steps First! CPU-Z \| SensorView \| WinXP Clean Boot \| Latest DirectX \| ATI Catalyst \| Nvidia ForceWare Posting System Specifications

05-22-2006, 08:27 PM	#2 (permalink)
Anne Troy Registered User Join Date: Apr 2006 Location: Columbia, MD Posts: 81 OS: XP	Hi, Gamerman. I once asked MrExcel how to do this because I didn't know how either. While I didn't test his directions, no one has told me they don't work. I took what he gave me and turned it into an article. See: http://www.officearticles.com/excel/...soft_excel.htm Bill calls them "Tiered Commissions"