Rounding Up to Nearest 1/4 Decimal

[Rosie]

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.

 

[Ron Rosenfeld]

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)

--ron

 

[Ken Wright]

=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
----------------------------------------------------------------------------

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.