The zero indicates the number of decimal places. If you use
=ROUND(A1,1) it will round A1 to 1 decimal place, e.g. for your example
76.3
if you use -1 it rounds to the nearest multiple of 10
so if A1 contains 76.25
=ROUND(A1,-1) would give you 80
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=522886