First, make sure the Analysis ToolPak is installed!
Menu: ToolsAdd-Ins... tick the Analysis ToolPak if it is not already
ticked.


Then use this formula:
=MROUND(A1,5)

It will round to the nearest 5-multiple.


HTH
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=389874