Thank you. So, if my price of 10.45 is in cell b5 (coming from a formula
a5*1.5), and I want it to go to 10.95, how do I do the formula? would it
be =b5........?
Thank you
--
MikeB94518


"Anne Troy" wrote:

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