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