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 [email protected]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
