View Single Post
  #1   Report Post  
Dajana
 
Posts: n/a
Default Rounding number to the nearest quarter

I am using Excel 2000 and I need to round up number to the nearest quarter.
For example if I enter 1.15 I want excel to round it up to 1.25, if entered
1.37 to round it up to 1.50 and so on. Is there a way to do this.

Thanks