One way:

Put this in, say, another sheet (which could be hidden):

A B
1 -1.0E+307 32
2 34.49999999999 37
3 41.49999999999 46
4 49.99999999999 53
5 56.49999999999 60
6 62.99999999999 66
7 70.99999999999 76
8 79.99999999999 84
9 88.99999999999 94
10 98.49999999999 105


And use the formula:

=VLOOKUP(J1, Sheet2!A:B, 2, TRUE)



In article ,
medic wrote:

I need to get excel to round a number to one of the following number those
numbers are
32
37
46
53
60
66
76
84
94
105