Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the commission rate% for different employees?
For a Sales Commission Calculator
I would like to be able to change the commission rate% for different employees. As well, I would like to adjust the rate automaticaly for different goals. ex.: employee under $100,000=1% commission then employee over $200,000=2% commission etc... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the commission rate% for different employees?
Hi, Your mail is more of a wish than a precise request ... From what you wrote, I would say it is feasible probably with sumproduct() function ... Carim -- Carim ------------------------------------------------------------------------ Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259 View this thread: http://www.excelforum.com/showthread...hreadid=531420 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the commission rate% for different employees?
Assuming your salesmancode is in column A, your sales in column B, your commission table in column F and G (0,100000,200000,300000,400000 in column F, 1,2,3,4,5 etc in column G), then =VLOOKUP(SUMIF(A$1:A$9,A1,B$1:B$9),F$1:G$5,2,TRUE) should achieve this. -- evdesign Wrote: For a Sales Commission Calculator I would like to be able to change the commission rate% for different employees. As well, I would like to adjust the rate automaticaly for different goals. ex.: employee under $100,000=1% commission then employee over $200,000=2% commission etc... -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=531420 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the commission rate% for different employees?
I believe that you can use in this case the If statement .eg if employee
payments <10000, 1%, if..... Hope this will help Ο χρήστης "evdesign" *γγραψε: For a Sales Commission Calculator I would like to be able to change the commission rate% for different employees. As well, I would like to adjust the rate automaticaly for different goals. ex.: employee under $100,000=1% commission then employee over $200,000=2% commission etc... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change the commission rate% for different employees?
If the first $100K makes 1%, then the next $100K makes 2%, etc., take a
look at the examples he http://www.mcgimpsey.com/excel/variablerate.html Use a different table for different employees. In article , evdesign wrote: For a Sales Commission Calculator I would like to be able to change the commission rate% for different employees. As well, I would like to adjust the rate automaticaly for different goals. ex.: employee under $100,000=1% commission then employee over $200,000=2% commission etc... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Find function | Excel Worksheet Functions | |||
Find function | Excel Worksheet Functions | |||
Cell Change Color - Need Help | New Users to Excel | |||
Help with Commission forumlas | Excel Worksheet Functions |