View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Huber57 Huber57 is offline
external usenet poster
 
Posts: 74
Default 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!