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
What I meant was: if the original numbers have a mixed number of decimal
cases you can't apply my solution because of the base 2 calculations.
But I assume that in a table you don't have values with 3 decimal cases
mixed with one decimal case?
Therefore you could go from 4 decimal cases to 1
On 19/02/11 00:38, Robert Prins wrote:
On Sat, Feb 19, 2011 at 00:24, plinopedl...@gmail.com 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
Hi all,
Andreas Säger schrieb:
Am 19.02.2011 00:50, Robert Prins wrote:
Why is there no standard function to do bankers rounding (aka
round-to-even)?
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_MROUND_function
Indeed, MROUND is not a standard function. It is part
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)
On Sat, Feb 19, 2011 at 00:24, plino pedl...@gmail.com 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))
Am 19.02.2011 00:50, Robert Prins wrote:
Why is there no standard function to do bankers rounding (aka round-to-even)?
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_MROUND_function
Indeed, MROUND is not a standard function. It is part of the (always
installed)
Am 19.02.2011 02:25, Andreas Säger wrote:
Am 19.02.2011 00:50, Robert Prins wrote:
Why is there no standard function to do bankers rounding (aka
round-to-even)?
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_MROUND_function
Indeed, MROUND is not a standard function.
On Sat, Feb 19, 2011 at 01:05, plino pedl...@gmail.com 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
11 matches
Mail list logo