On Sat, Feb 19, 2011 at 01:05, plino <[email protected]> wrote: > > 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 :)
Actually, that is exactly what I am looking for, a round function that allows me to do bankers rounding on *any* decimal position I choose. I have files where I need to round-to-even to one decimal place... Robert -- Robert AH Prins [email protected] -- 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 ***
