So, based on that, you need the first number that is greater than or equal to the number you specify, not just the closest number.

If your data is not in sorted order, you'll have to use the formula I have above. (The second one, entered with CTRL+SHIFT+ENTER)

There should be a different way to do it with them in sorted order, but off the top of my head... i can't think of it right now for some reason. Will continue to think about it and come back if I have an answer for you... or someone else may know it.

Scott