Re: [libreoffice-users] The way SUM works

On 12/20/2011 05:32 PM, nvrk wrote:
> The number displayed in a Calc cell is limited in decimal places by the
> formatting preference.  Set the number format for the cells to show more
> decimal places and see the results.
>
> In your case the sum calculation is based on the actual multiplication
> result in the individual cells to a large number of decimal places, and
> then the displayed sum shortened to show the decimal places set by the
> formatting preference.
>
> The (sum of the original entries) multiplied by (1,22) displayed to two
> decimal places is not likely to display exactly the same as the sum of
> (individual entries) multiplied by (the same multiplier).
>
> Take a look at the 'ROUND' function.
For each calculation in B use for example =round(a2*1.22,2) you will get 
a total of -1199.62
Rounding the sum of column A then rounding results in -1199.64
> On Tue, Dec 20, 2011 at 1:28 PM, Dominik Wnęk<dominik@ode2.com>  wrote:
>
> > Hello,
> >
> > I have a problem with the way SUM works. At first I thought this was a
> > bug, but then I saw Numbers on my iPad doing the same thing, so now I
> > believe this is by design, but I have no idea why and how I can work around
> > this.
> >
> > Take a look at this example:
> >
> > http://www.ode2.com/images/**libreoffice_sum.tiff<http://www.ode2.com/images/libreoffice_sum.tiff>
> >
> > The number format is currency (Polish Zloty), the numbers in the left
> > column are entered by hand, the ones in the right one are calculated by
> > multiplying the left number by 1,22.
> >
> > The sum of the numbers in the right-hand column should be -1199,62, but it
> > is off by 0,02 zł. It's pretty obvious this is because the program sums the
> > numbers it has in memory and not the ones it displays.
> >
> > If this behaviour is correct, how can I work around this? I just spent 40
> > minutes trying to find out why my balance is wrong only to find out the
> > sums I was doing were giving me incorrect amounts :/
> >
> > Thanks,
> >
> > --
> > Dominik
> >
> >
> >
> >
> > --
> > For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> > org<users%2Bhelp@global.libreoffice.org>
> > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> > Posting guidelines + more: http://wiki.**documentfoundation.org/**
> > Netiquette<http://wiki.documentfoundation.org/Netiquette>
> > List archive: 
> > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> > All messages sent to this list will be publicly archived and cannot be
> > deleted


--
Jay Lozier
jslozier@gmail.com


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted