Rounding Up to Nearest 1/4 Decimal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. How do I round up to the nearest quarter decimal place? i.e. The value 5.71 should be 5.75 and 5.76 should be 6.0.
 
=CEILING(A1,0.25)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



Rosie said:
Hello. How do I round up to the nearest quarter decimal place? i.e. The
value 5.71 should be 5.75 and 5.76 should be 6.0.
 
Back
Top