1. Is it possible to do this excel?
Try this
=FLOOR(A1,0.05)
Mike
"san" wrote:
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.
|