round numbers to the nearest quarter?

[LeelooIvy]

How do you round numbers to the nearest quarter?

 

[JE McGimpsey]

One way:

=ROUND(A1*4,0)/4

 

[CLR]

Another........
=MROUND(A1,0.25)
or if you're doing pricing you may want
=ROUNDUP(A1*4,0)/4

Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

Or even:
=CEILING(A1,0.25)
(for an alternative for the =roundup() sample)