how do I get excel to round to specific numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
Slope from a range of cells 1
Excel How to find the most common pairs and triplets numbers? 5
Record Click on Error Indicator 2
stop numbers auto rounding 2
Rearrange numbers from a column in a different order in a second c 14
Sumproduct Problem 4

Back
Top