try
=IF(H810,10,IF(H85,9,IF(H83,8,0)))

--
Don Guillett
SalesAid Software

"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