On 20-07-2013 01:26, toodr wrote:
I had the same problem. I needed to implement the so called Bankers' Rounding
Function,
if i read correctly at:
http://en.wikipedia.org/wiki/Rounding
Round half to even[edit]
A tie-breaking rule that is less biased is round half to even, namely:
If the fraction of y is 0.5, then q is the even integer nearest to y.
Thus, for example, +23.5 becomes +24, as does +24.5; while −23.5 becomes
−24, as does −24.5.
This method treats positive and negative values symmetrically, and is
therefore free of sign bias. More importantly, for reasonable
distributions of y values, the expected (average) value of the rounded
numbers is the same as that of the original numbers. However, this rule
will introduce a towards-zero bias for even numbers (including zero),
and a towards-infinity bias for odd ones.
This variant of the round-to-nearest method is also called unbiased
rounding, convergent rounding, statistician's rounding, Dutch rounding,
Gaussian rounding, odd-even rounding,[3] bankers' rounding or broken
rounding, and is widely used in bookkeeping.
This is the default rounding mode used in IEEE 754 computing functions
and operators.
This means that your function does not work correctly i.e.
23,574 should be rounded to 23,58, you function gives 23,57
so, i tried to create a function hwich lives up to my expectations... ;)
(but i NEVER used 'Bankers' Rounding'......)
function bround(i as double, Optional d as integer)
dim format as string
dim tmp as string
dim c as double
svc=createUnoService("com.sun.star.sheet.FunctionAccess")
if IsMissing(d) then d=2
bround = svc.callFunction("ROUND", array(i/2, d))*2
end function
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
