|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
How do I round numbers to the nearest multiple of 10 or 5?
What do y'all have against MROUND?
=MROUND(A1,10)
=MROUND(A1,5)
Die_Another_Day
Dav wrote:
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
|