Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 2

Sales Commission Rates

I'm trying to calculate a new sales commission based upon a range possible
values.

Sales Rep earns a different commission based upon Margin % on the sale.

A simple version table is this:
From Until
0.0% 2.99% 0.00%
3.0% 9.99% 1.00%
10.0% 14.99% 1.25%
15.0% 19.99% 1.75%
20.0% 25.99% 2.50%
26.0% 3.25%

(The actual table is much more detailed and does not work using Vlookup)

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
Calculating sales commission that changes based on a sales volume	Elbowes	Excel Worksheet Functions	2	June 8th 07 02:48 PM
Sales V commission	Carauto	Excel Worksheet Functions	2	December 9th 05 01:22 AM
Sales Commission calculations	Kevin	Excel Worksheet Functions	0	July 25th 05 04:15 PM
sales commission template	trey	Excel Discussion (Misc queries)	0	December 4th 04 02:32 PM

All times are GMT +1. The time now is 08:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us