Rounding question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

masspete@my-deja.com - 26 Jun 2006 22:55 GMT

I am having trouble getting my head around exactly how to approach a
rounding issue, and maybe someone can help.

I am converting some prices across currencies that follow a pattern --
multiplied by an exchange rate, then rounded up to .95 (if cents are
1-95), or down to .95 (if cents are 96, 97, 98, 99, or 0). As it is
now, Excel is doing th multiplication, and I'm going back and doing the
rounding manually. Does anyone know a reasonable way to do this with a
formula?

Reply to this Message

Peo Sjoblom - 26 Jun 2006 23:18 GMT

With the data in A1

=CEILING(A1,1)-0.05

Signature

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

>I am having trouble getting my head around exactly how to approach a
> rounding issue, and maybe someone can help.
[quoted text clipped - 5 lines]
> rounding manually. Does anyone know a reasonable way to do this with a
> formula?

Reply to this Message

masspete@my-deja.com - 03 Jul 2006 10:05 GMT

> With the data in A1
>
[quoted text clipped - 21 lines]
> > rounding manually. Does anyone know a reasonable way to do this with a
> > formula?

Thanks very much! Worked like a charm. Really appreciate the help.

Reply to this Message