rounding nearest five

  • Thread starter Thread starter mjl2003
  • Start date Start date
M

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


:
 
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
 
Mike

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

=MROUND(number,5)

number can also be cellref

Gord Dibben Excel MVP
 
Back
Top