IF alternative

Hello. Tiny little problem.

For any given number, I want it to by raised to the next superior value from a specific list of values.

E.g. the list would be something like this: 9, 13, 18, 25, 41, ...
If the number is 11.232 then it will be replaced by 13,
if the number is 24.311 then it will be replaced by 25.

The list contains dozens of numbers, so the IF option won't work.

Optionally, I want that numbers that don't exceed their next inferior value from the list with more than 0.5 to be replaced with that inferior value.

E.g. If the number is 13.49 then it will be replaced by 13, but if the number is 13.51 then it will be replaced by 18.

Perhaps something along the lines of:

Please Login or Register  to view this content.

where A1 contains the input and Col B the list

I based on expected delimiter (that said I used 0.5 rather than 0,5)

Try:

Please Login or Register  to view this content.