Try the Cieling() and Floor() functions
e.g. =Cieling(A1,10) will round up to nearest multiple of 10
=Floor(A1,10) will round down to nearest multiple of 10
--
Vito
------------------------------------------------------------------------
Vito's Profile:
http://www.excelforum.com/member.php...o&userid=29182
View this thread:
http://www.excelforum.com/showthread...hreadid=558898