Rounding up

[Chris]

Does anyone know the formula for rounding up to the next
quarters. Example 1.66 should round to 1.75, 2.11 should
round to 2.25. Thanks

 

[Domenic]

Hi Chris,

Try,

=CEILING(A1,0.25)

Hope this helps!

 

[Andy B]

Hi

Try this:
=ROUNDUP(A1/0.25,0)*0.25