Thread: Rounding up
View Single Post
  #2  
Old June 15th, 2004, 02:09 PM
Domenic
external usenet poster
 
Posts: n/a
Default 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