Convert and round up to closest .25

Hi,

I'm trying to convert from oz to cl but I want the result to round up to closest .25.

This is how I did it for oz to ml: =roundup(convert(C2,"oz","ml"),0)

How would I do this if I wanted to round up to the closest .25?

Thanks in advance!

Hello and welcome to the forum.

Try this:

=CEILING(CONVERT(C2,"oz","ml"),0.25)

Originally Posted by 63falcondude

Hello and welcome to the forum.

Try this:

=CEILING(CONVERT(C2,"oz","ml"),0.25)

Perfect, thanks! Exactly what I has after!

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.