Rounding help

[bkelly301]

I have a problem, for which roundup, rounddown, MROUND, or round doesn't fix. I was wondering if someone could possibly help me here.

Here are the steps to the problem, and I am looking for 9 9/32 as the answer:

- I want to round 9.2554 UP to the nearest 1/32 fraction, which would be 9 9/32.

I want the outputted answer to be 9 9/32 (or 9.28125)

Basically, I want that 9.2554 to round UP to the nearest 1/32.

If I do =MROUND(value, 1/32), then it rounds to the closest 1/32 fraction, which is 9 1/4. But I want it to round UP to the nearest 1/32.

Please help. Thanks a lot

[6StringJazzer]

try

=CEILING(value,1/32)

[bkelly301]

AWESOME!!!!

Thanks a lot!!!

Now, is there a way to make it round down as well??

like 9.279 rounding DOWN to 9 1/4"?

Thanks again.

EDIT: Nevermind, I tried "floor", and it worked!!!

Thanks again!