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

So if the number 33 was input, would it need to use 32 or the next highest number?
(Closest or Next Highest number)
"medic" <(E-Mail Removed)> wrote in message
news:E258C061-5AAF-4D2F-8ADF-(E-Mail Removed)...
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

Round up or down ?

NickHK

"medic" <(E-Mail Removed)> wrote in message
news:E258C061-5AAF-4D2F-8ADF-(E-Mail Removed)...
> 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
>

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 <E258C061-5AAF-4D2F-8ADF-(E-Mail Removed)>,
medic <(E-Mail Removed)> 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