Here is my current, incorrect formula:
=IF(Q5="","",IF(Q5$Q$25,0,IF(Q5=$Q$26,((Q5-$Q$25)/($Q$26-$Q$25))*($R$26-$R$25)+$R$25,IF(Q5<$Q$26,((Q5-$Q$26)/($Q$27-$Q$26))*($R$27-$R$26)+$R$26,0))))

Target................Points
Min......Q24 3.40 1.25 R24
Mid......Q25 3.06 5.00 R25
Max.....Q26 2.45 10.00 R26

As you can see, the lower the score the better. The most points you
SHOULD get would be 10.00 points. However, if I get a score of 2.44,
which is really good, I get 10.08 instead of 10.00. I want the cut-off
to be 10.00.

Should be If greater than or equal to R26 then receive 10.00 points.

Where am I going wrong?

-Chuck-


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