Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I get excel to round to specific numbers?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I get excel to round to specific numbers?
So if the number 33 was input, would it need to use 32 or the next highest number?
(Closest or Next Highest number) "medic" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I get excel to round to specific numbers?
Round up or down ?
NickHK "medic" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I get excel to round to specific numbers?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does excel round off numbers greater than 16 digits? | Excel Discussion (Misc queries) | |||
HOW DO I SELECT ROUND NUMBERS ONLY IN EXCEL SPREADSHEET | Excel Worksheet Functions | |||
Why does a spreadsheet sent in Excel round numbers when mailed? | New Users to Excel | |||
Does Excel round numbers with a 5 in the tens place? | Excel Discussion (Misc queries) | |||
Can you round numbers to display a specific set of numbers, for e. | Excel Discussion (Misc queries) |