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