Hi, Mike. I always do it this way: Round up to the nearest dollar, then
subtract a nickel. Like:

=roundup(a1,0)-.05
*******************
~Anne Troy

www.OfficeArticles.com



"MikeB94518" wrote in message
...
I have various prices / 5.26, 2.14, 16.58 that I want to round up to the
next
.95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do
this?
Thank you.
--
MikeB94518