Help Tring to Place Value on top three

Hello can anyone please help.

I am trying to do the following
2.09 1
1.66 0
2.83 2
1.58 0
2.6 2
1.6 0
3.03 #REF!
3.36 #N/A

Colum one is a value
Colum two is a point associated to that Colum, I was using the following
=IF(B9="-",0,IF(B9>=2.41,2,IF(B9>=2,1,IF(B9<=1.99,0,0))))

but now instead of spec values I need to do the following
(0 - 2.49) 0 pts
2.50 > 1 pts
TOP 3 2 pts


Does anyone have any suggestions as I am not sure how to do this in only the two columns?
I am also using conditional Formatting so each is a different color so they need to match

Assuming your first item of data is in B9, put this in C9:

=IF(RANK(B9,B$9:B$16)<=3,2,IF(B9<2.5,0,1))

then copy down.

Hope this helps.

Pete

Thank you Pete_UK that did work for most but now i have run into a different problem

when i am working on the following the one you gave will not work. it is giving me a score where it is the highest instead of lowest. I have tried to play with the formula you gave but did not work. Any suggestions?



901 > 0 pts
851 - 900 1 pts
LOWEST 3 2 pts


Score Points
523.00 1
813.00 1
1082.00 2
618.00 1
873.00 1
741.00 1
778.00 1
548.00 1
- 0
1044.00 2
891.00 1
816.00 1
1128.00 2
913.00 1
813.00 1