|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
How do I round numbers to the nearest multiple of 10 or 5?
10 =ROUND(A1,-1)
5 ==ROUND(2*A1,-1)/2
if your value is in a1
regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=558461
|