Hi Everybody!

Thanks to all for your replies. What I actually want to do is to first
increase our prices 3% and then round off to the nearest 48 cents or 98
cents. For instance, if after increasing a price 3% it comes out to lets
say, $48.05, I'd like to round it down to $47.98. However, if after
increasing a price 3% it comes out to $48.25 I'd like to round up to $48.48.
I'm going to try these formulas that were suggested to see how they work.
With the formulas suggested, do you think this will work? If they don't can
you suggest something else. Thanks again, Mark
--
Mark


"Martin Fishlock" wrote:

Mark,

Do you round up down or off. This is quite important and you may ineffect
loose margin.

You may also need to consider sales taxes if your prices are after tax.

Why because the calculation of the the tax can cause a difference of 0.01
when you work backwards.

But the replies from Ron and JMB are good.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"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