Rounding off

[ace]

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

 

[Jim Thomlinson]

assuming the value is in a1

=round(a1/25, 0)*25

 

[Luke M]

I think you are using MROUND incorrectly, as it should do what you are asking
for.

=MROUND(310,25)
evaluates to 300, whereas
=MROUND(315,25)
evaluates to 325

 

[ace]

Guys,
Got it, it works like a charm.

Thanks,
Much appreciated,
Ace