MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Rounding to nearest multiple of 5


Posted by Don C on February 12, 2002 9:25 AM

Given a column of numbers, we want to round to the nearest multiple of 5.

I found on this board the FLOOR function, but that takes a number to the next lowest multiple of 5. I want the nearest multiple of 5, so sometimes it rounds up and sometimes it rounds down.

Thanks


Posted by IML on February 12, 2002 9:31 AM

If you have the analyst tool pak installed, use
=MROUND(A1,5)

otherwise you could use
=ROUND(A1/5,0)*5