Another option assuming only numbers in A1. I'm not sure about numbers like
5.5 & 10.5. :o
=8*(A13)+(A15)+(A110)

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"Rikuk" wrote in
message ...

Hi need help with the following I've a cell with a value of between 3 &
11, I need to see if that cell meets a criteria to rate accordingly.

between 3 & 5 = 8 points
between 6 & 10 = 9 points
11+ = 10 points

Rik


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile:
http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=526266