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