Hi,

With your list in A1 - A7 and your number in b1 try this

=INDEX(A1:A7,MATCH(MIN(IF(A1:A7-B1=0,A1:A7,FALSE)),IF(A1:A7-B1=0,A1:A7,FALSE),0))

Array entered with Ctrl+Shift+Enter

Mike

"Huber57" wrote:

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!