Need to round UP to values from a table.

[jomofro39]

Hello again,
It was so helpful last time, so I figured I would post here again.
Basically, I want the accumulator volume to only round UP to one of the values listed in the table. I am using a vlookup right now, but that still rounds it down as well, and from what I could find on the forum, ceiling won't help me because the intervals are not uniform. Any help is appreciated.
-Alex

[daddylonglegs]

One way is to use an "array formula" like this

=MIN(IF(E2:E13>=B1,E2:E13))

confirmed with CTRLSHIFT+ENTER

[jomofro39]

I did that and for some reason for the value of 12.65, instead of giving me 15.0, it gave me the lowest value, 0.25. I do not know what it's deal is.

[jomofro39]

nvm. I had the wrong cell highlighted for the value. You are the man, thanks!