Rounding Question - Advanced?

[fascsam]

Yesterday I posted a request to round a number to the nearest .25 as in 330.30 needs to be rounded to 330.25

Someone suggested using the "floor" formula, but it only rounds DOWN to the next .25... I need to round to the NEAREST .25

Any ideas? Please help!

 

[Richie(UK)]

Hi fascsam,

How about =25*ROUND((A1/25),2) where the value to be rounded is in A1?

HTH

 

[fascsam]

Nice - thank you!

 

[Aladin Akyurek]

On 2002-10-15 08:44, fascsam wrote:
Nice - thank you!

Can be shorter...

=ROUND(A1/0.25,0)*0.25