Hi,

Thanks so much for such a quick reply. I tried your function
=FLOOR(G1,0.05) on my worksheet, but on few cells it gave me result like
this

219.40---219.35 which should remain 219.40
219.55---219.50 which should remain 219.55

I wonder why it happened. Please help me on this too. Thanks.

San


"san" wrote in message
.. .
Hi friends, i have a small query if you got little time. i have many
numbers in an excel worksheet and i want to round them up only for decimal
places and that too like this way.
219.39---219.35
219.32---219.30
219.34---219.30
219.37---219.35

I mean decimal places must end in .05, .10, .15, .20, .25, .30, so on.
what is the function for this result. thanks in advance.