Daniel Devor wrote
> The LO instructions refer to "insert-file" but I cannot find any such
> in my copy of LO. Please advise how to run this function since my need
> is to do just that--insert or add a file to another. LO 5.3.03
Depending on your needs, in addition to the Insert -> Document men
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:
=IF(ROUND(100*A1-INT(100*A1),8)=0.5,IF(MOD(ROUND(100*A1-0.5
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 com
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 com
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))
>>
Hi Regina,
Am 19.02.2011 15:16, Regina Henschel wrote:
I think, MROUND will work for Robert. Examples:
Round to nearest even Cent:
MROUND(12.354;0.02) results in 12.36
But the bankster rounds to 12.35
MROUND(-12.328;0.02) results in -12.32
But the bankster rounds to -12.33
Round-to-even
Gordon Burgess-Parker wrote on 2011-02-19 12:22:
> All you need to do is to set the cell format to be 2 decimal places. If
> you then enter 123.455 into a cell that will round up to 123.46
> automatically for youno need for any sort of complicated formulae
This is only the display form
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
On 19/02/11 00:38, Robert Prins wrote:
On Sat, Feb 19, 2011 at 00:24, 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
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 in
On Sat, Feb 19, 2011 at 01:05, plino 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. Other
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. I
On 18 February 2011 18:24, plino wrote:
> I had never heard of bankers rounding before. Interesting concept.
I never heard it called that until recently, but was taught it many
years ago. I prefer it because it is more accurate. But it requires
more intelligence than most apps have. :-)
> There
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) Analysi
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.
No
On Sat, Feb 19, 2011 at 00:24, 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
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
17 matches
Mail list logo
