Rounding results to nearest quarter (in decimals)

I have a formula that results gives results like 22.63. Is there a way to get it to round up to the nearest quarter number. For example 22.63 would round up to 22.75 or 133.10 would round up to 133.25.

Is this possible?

Good evening djarcaian

Certainly is - just use the CEILING function. Assume that your 22.63 is in A1. Put this formula in B1:

=CEILING(A1,0.25)

HTH

DominicB

I figured this out-

=ROUND(SUM(G25/2)*4,0)/4

Is there any reason to use the CEILING system instead of this system?

Hi djarcadian

Noy really. It's just tidier, and does exactly what it was designed to.

DominicB

Thanks!

If you can use the Analysis toolpack, there's a very cool function called
MROUND
=MROUND(G25,.25)
would be the formula, I believe.
************
Anne Troy
www.OfficeArticles.com

"djarcadian" <[email protected]> wrote
in message news:[email protected]...
>
> I figured this out-
>
> =ROUND(SUM(G25/2)*4,0)/4
>
> Is there any reason to use the CEILING system instead of this system?
>
>
> --
> djarcadian
> ------------------------------------------------------------------------
> djarcadian's Profile:
> http://www.excelforum.com/member.php...o&userid=15877
> View this thread: http://www.excelforum.com/showthread...hreadid=479639
>