Re: [libreoffice-users] Re: Missing function: Bankers Rounding

On 19/02/11 00:38, Robert Prins wrote:
> On Sat, Feb 19, 2011 at 00:24, plino<pedlino@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))
> >
> > (Adjust if your separator is a comma instead of a  semi-colon)
> >
> > What this does is check if the fractional part is 0.5 and adds 0.5 to the
> > number if the integer is odd and subtracts if it is even. If  it is not 0.5
> > then it uses the regular Round() function ;)
> >
> > Hope this helps!
> Yes, but mostly no...
>
> The above works for 22.5 and -1234.5, but now I want to deal with currencies...
>
> Like $ 123.455 or € 99.125, which should be rounded to $ 123.46 and € 99.12
>
> In other words, the issue is slightly more complicated...
>
> Robert
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 you....no need for any sort of complicated formulae....

--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***