"Daniel Sloan"
wrote in message
news:Daniel.Sloan.2b7ne6_1153342808.7607@excelforu m-nospam.com...

Hi

I have a price list to update and want to know how to use an excel
formula to round the result to the nearest whole 5cent value.

=MROUND(A1,0.05)
--
David Biddulph