Bruce's formula doesn't account for the part of your original request
for values that equal 10, 9 or 8.

The formula to cover that would be:

=IF(A1=10,5%,IF(A1=9,4%,IF(A1=8,3%,0)))


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=480863