Maybe someone will take a look at my first post and steer me in the
right direction with my IF statement.

Kevin, sometimes an employees data will hit the target, other times
they won't. If it doesn't hit the target, I need Excel to be able to
calculate just how many points they should receive. If a score of 10.00
yields 3.00 reward points, what if they score 7.75 points, or 9.00
points. How many reward points would they then receive. Hey man, I
really appreciate your posts, I'm about to pull my hair out ;)

-Chuck-


--
Dropdown3
------------------------------------------------------------------------
Dropdown3's Profile: http://www.excelforum.com/member.php...o&userid=30321
View this thread: http://www.excelforum.com/showthread...hreadid=505440