Round to nearest 5 cents
=ROUND(A1/5,2)*5
or
=MROUND(A1,0.05)
(Requires the Analysis Toolpak)
© Copyright 2004 - 2007,
andrewsexceltips.com
. All Rights Reserved.