Rounding question

  • Thread starter Thread starter masspete
  • Start date Start date
M

masspete

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?
 
With the data in A1

=CEILING(A1,1)-0.05

--

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
 
Peo said:
With the data in A1

=CEILING(A1,1)-0.05

--

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
Click to expand...

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