assuming the value is in a1

=round(a1/25, 0)*25
--
HTH...

Jim Thomlinson


"ace" wrote:

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