Menu

sliding commission calculation

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming

JE McGimpsey JE McGimpsey is offline

JE McGimpsey is offline

external usenet poster

Posts: 4,624

Default

sliding commission calculation

See

http://www.mcgimpsey.com/excel/variablerate.html

In article .com,
wrote:

Five tiered commission system:

Commission Tier 1: $0.0 - 2.0 @ 20%
Commission Tier 2: $2.1 - 4.0 @ 21%
Commission Tier 3: $4.1 - 6.0 @ 22%
Commission Tier 4: $6.1 - 8.0 @ 23%
Commission Tier 5: $8.1 to infinity @ 24%

The numbers are all fake, I am just looking for the formula.

How do I put this into Excel in a formula so that all I have to do is
enter the number and know what commission is going to be?

Preferably I'd like to do this in five different cells. For example...

Say the commissionable amount is: 5.8; I'd like the sheet to show
something like this:

Commissionable Amount: 5.8

Commission Tier 1: $0.4
Commission Tier 2: $0.399
Commission Tier 3: $0.374
Commission Tier 4: $0.00
Commission Tier 5: $0.00

Total Commission: $1.173

This is driving me crazy and I am not a nube at this stuff.

Thanks for the help.
T

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sliding commission rates in excel	[email protected]	Excel Worksheet Functions	4	July 17th 08 09:40 PM
Sliding 30 day calculation	Bill	Excel Discussion (Misc queries)	1	October 4th 07 08:11 PM
Sliding scale commission percentages formulas	Margs	Excel Worksheet Functions	7	September 8th 07 11:33 PM
Percentage Commission on a sliding scale.	JonPFP	Excel Discussion (Misc queries)	6	April 13th 06 06:24 PM
calculating commission on sliding scale	corrado444	New Users to Excel	4	December 9th 05 05:08 PM

All times are GMT +1. The time now is 09:48 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement