how do I get excel to round to specific numbers?

G

Guest

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
 
C

Corey

So if the number 33 was input, would it need to use 32 or the next highest number?
(Closest or Next Highest number)
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
 
J

JE McGimpsey

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to group a table using VBA? 3
I need elegance..... 10
Excel How to find the most common pairs and triplets numbers? 5
Slope from a range of cells 1
Record Click on Error Indicator 2
Rearrange numbers from a column in a different order in a second c 14
VB Function Round vs Excel function Round not behaving the same Od 5
Creating combinations based on a criteria 6

Top