Hi Everybody!

I just wanted to thank everyone who posted for their help. The formual that
works is the one suggested by JMB:

Or, you may want to round the result after the 3% increase before rounding
to the nearest 0.48 or 0.98:
=MROUND(ROUND(A1*1.03,2)+0.02,0.5)-0.02

This will sure make it much easier to increase our pricing. Thanks again,
Mark
--
Mark


"Mark4253" wrote:

Hi!
My company is increasing prices 3%. My boss likes everything rounded off to
the nearest 48 cents or 98 cents. Is there a formula for increasing our
prices 3% then rounding it off to the nearest 48 cents or 98 cents, whichever
is closer after being increased 3%. Thanks,
--
Mark