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

I had never heard of bankers rounding before. Interesting concept.

There is no such function in OOo/LO, Excel or Gnumeric...

But you can easily create a function

=IF(A1-INT(A1)=0.5;IF(ISEVEN(INT(A1));A1-0.5;A1+0.5);ROUND(A1))

(Adjust if your separator is a comma instead of a  semi-colon)

What this does is check if the fractional part is 0.5 and adds 0.5 to the
number if the integer is odd and subtracts if it is even. If  it is not 0.5
then it uses the regular Round() function ;)

Hope this helps!
-- 
View this message in context: 
http://nabble.documentfoundation.org/Missing-function-Bankers-Rounding-tp2530641p2530764.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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 ***