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?


--
djarcadian
------------------------------------------------------------------------
djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877
View this thread: http://www.excelforum.com/showthread...hreadid=479639

Rounding results to nearest quarter (in decimals)
 

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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=479639

Rounding results to nearest quarter (in decimals)
 

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

Rounding results to nearest quarter (in decimals)
 

Hi djarcadian

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

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=479639

Rounding results to nearest quarter (in decimals)
 

Thanks! :)


--
djarcadian
------------------------------------------------------------------------
djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877
View this thread: http://www.excelforum.com/showthread...hreadid=479639

Rounding results to nearest quarter (in decimals)
 

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" wrote
in message ...

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