If you don't want any errors even in the 10th digit, I think it's probably a
good idea to use ROUNDUP and ROUNDDOWN instead of adding or subtracting
0.005 for the final result. So, my final function for a Bankers Round that
I'm using is:
colinkeenan wrote:
plino wrote:
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
plino wrote:
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