View Single Post
  #2   Report Post  
dominicb
 
Posts: n/a
Default 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