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.


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

If you have the analyst tool pak installed, use

otherwise you could use