rounding nearest five

[mjl2003]

Hi Everyone

I am trying to find a formula that would allow me to round numbers t
the NEAREST five. I have tried using the ceiling feature to round t
five. The problem is it rounds UP by five, not to the nearest five.

For example I want a way to round the number 131.25 to 130. While i
the same row numbers like 134.00 would round up to 135.00

I am sure there is a way to do this I am just not sure how. Any hel
would be great.

Thanks
Mike


:

 

[Jim Rech]

You could use the MROUND function in the Analysis Toolpak, but I usually opt
for using the built-in Round worksheet function like this :

=ROUND(A1/5,0)*5

 

[Gord Dibben]

Mike

With Analysis Toolpak add-in loaded........

=MROUND(number,5)

number can also be cellref

Gord Dibben Excel MVP

 

[mjl2003]

That works great

Thanks Guys