Rounding question

[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?

 

[Peo Sjoblom]

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

 

[masspete]

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

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