Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round to a number in a list
Hello:
I have a list of numbers: 10 15 200 300 500 650 775 I have a cell that returns numbers in between 10 adn 775 (example: 214). I need that number to round to the next higher number in the list (in this case: 300). I have tried Rounding in several ways and it hasn't worked. Does this require an array formula? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round number to the thousands without changing underlying number | Excel Discussion (Misc queries) | |||
Excel. How to round a number to nearest half number? | Excel Discussion (Misc queries) | |||
Can I increase a number by 5.5% and then round that number to the. | Excel Discussion (Misc queries) | |||
How can i round a number to closest tenth number? | Excel Worksheet Functions | |||
How to make a number round up/down to a set number | Excel Worksheet Functions |