Thread
:
Rounding up
View Single Post
#
2
June 15th, 2004, 02:09 PM
Domenic
external usenet poster
Posts: n/a
Rounding up
Hi Chris,
Try,
=CEILING(A1,0.25)
Hope this helps!
In article ,
"Chris" wrote:
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