More Formula Help

[Steve]

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?

 

[Jim Cone]

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,25})

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




"Steve" <[email protected]>
wrote in message

 

[Steve]

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,25})

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

"Steve" <[email protected]>
wrote in message





- Show quoted text -

it works with whole #'s Thanks Jim. i could make this work, but
anyway for the formula to work with the % in there?

 

[Steve]

it works with whole #'s  Thanks Jim.  i could make this work, but
anyway for the formula to work with the % in there?- Hide quoted text -

- Show quoted text -

Forget that last question....i figured it out....thanks a million
Jim!!!!!