It is not clear to me what you are trying to accomplish, but this will limit
the answer to 10:

=IF(Q5="","",IF(Q5<$Q$26,10,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))))


Here is an example IF construction:

=IF(Q5<Q26,"Less than q26",IF(Q5<Q25,"less than q25",IF(Q5<Q24,"less than
q24",0)))

--
Damon Longworth

2006 East Coast Excel User Conference
April 19/21st, 2006
Holiday Inn, Boardwalk
Atlantic City, New Jersey
Early Bird Registration Now Open!!
www.ExcelUserConference.com

2006 UK Excel User Conference
Summer, 2006
London, England
"Dropdown3" wrote in
message ...

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