HI
(1)
Excelforum
(1)
System
(1)
Sales
(1)
Salespersons
(1)
Points
(1)
Column
(1)
Assign
(1)

Assigning a points scoring system

16-May-06 09:28 PM
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     |
+-------------------------------------------------------------------+

--
zelus
------------------------------------------------------------------------
zelus's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34510
View this thread: http://www.excelforum.com/showthread.php?threadid=542752
Post Question To EggHeadCafe