With the Close Rate in cell B2 and using whole numbers...

=LOOKUP(B2,{0,25,27,33,35,40,1001},{0,6,12,18,22,2 5})

--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Calculate Payments add-in: amount, interest rate, payment, term - in the free folder)




"Steve"
wrote in message
...
I am trying to set a point value to change when a certin value is
achived. Here is an example:
Sales rep Tamra makes 3 orders for every 10 calls she recives, so she
has a 30% close rate and recives 12 pts. Tamra's goal is to close 40%
of her calls to achive the 25pt maxium. Here is our point scale:

Close Rate Pts.
< 25% 0
= 25% and < 27% 6
=27% and < 33% 12
= 33% and < 35% 18
= 35% and < 40% 22
= 40% 25

Is it possiable to enter this data in a single formula?