It's only slightly more complicated :) =IF(VALUE(RIGHT(A9))=5;IF(ISEVEN(VALUE(LEFT(RIGHT(A9;2))));A9-0.005;A9+0.005);ROUND(A9;2))
Check if the last digit is 5. If it is add 0.005 if the previous digit is odd or subtract if it is even. Otherwise use the standard round function with two cases. Now, if the numbers of decimal cases is not constant, then it would be complicated :) -- View this message in context: http://nabble.documentfoundation.org/Missing-function-Bankers-Rounding-tp2530641p2530915.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 ***
