Hi
Cell A2 26.6 =10
Try this
cell B2 =LOOKUP(A2, {0,25.7,26.2,26.7,27.2,27.7,28.2,28.7,29.2,29.7}, {10,8,7,6,5,4,3,2,1,0}) copy down