Re: [libreoffice-users] Re: Missing function: Bankers Rounding

Hi all,

Andreas Säger schrieb:
> Am 19.02.2011 00:50, Robert Prins wrote:
> > Why is there no standard function to do bankers rounding (aka
> > round-to-even)?
>
>
>
> http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_MROUND_function
>
>
> Indeed, MROUND is not a standard function. It is part of the (always
> installed) Analysis add-on.

I think, MROUND will work for Robert. Examples:

Round to nearest even Cent:
MROUND(12.354;0.02) results in 12.36
MROUND(-12.328;0.02) results in -12.32

Round-to-even to one decimal place
MROUND(3.49;0.2) results in 3.4
MROUND(2.51;0.2) results in 2.6

Kind regards
Regina

--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***