Z
zelus
HI
New user to this forum and after some help on my attached file.
I want to assign a points scoring system to my sales staff.
In column E i have the sales person's average units per sale. I have a
table to far right with a scoring system based on there units per
sale.
Can i insert a formula in column F that will assign the proper point
score the the salespersons unit per sale result.
Thanks for your help
+-------------------------------------------------------------------+
|Filename: Sales Net of.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4773 |
+-------------------------------------------------------------------+
New user to this forum and after some help on my attached file.
I want to assign a points scoring system to my sales staff.
In column E i have the sales person's average units per sale. I have a
table to far right with a scoring system based on there units per
sale.
Can i insert a formula in column F that will assign the proper point
score the the salespersons unit per sale result.
Thanks for your help
+-------------------------------------------------------------------+
|Filename: Sales Net of.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4773 |
+-------------------------------------------------------------------+