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!
|