mround is your friend

whereby 10 is the multiple you want (you can change this)

eg

=MROUND(F17,10)

eg

if F17 = 13 value = 10


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=568448