Rounding up

Chris · Jun 15, 2004

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 · Jun 15, 2004

Hi Chris,

Try,

=CEILING(A1,0.25)

Hope this helps!

Andy B · Jun 15, 2004

Hi

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