Thread: Rounding off
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ace ace is offline
external usenet poster
 
Posts: 19
Default Rounding off

Guys,

I have a question.
Suppose I have a column which has values ;
300
315
330
390

Now i want these values rounded off to the nearest quarter,

eg, 300 remains 300.
315 becomes 325
330 becomes 325
and 390 becomes 400

I tried using mround but that rounds off everything to the NEXT quarter.

Any way i can do this automatically??

Thanks,
Ace