Rounding results to nearest quarter (in decimals)

[djarcadian]

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

Is this possible

 

[djarcadian]

I figured this out-

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

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

 

[dominicb]

Hi djarcadian

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

Dominic

 

[djarcadian]

Thanks! :

 

[Anne Troy]

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