Re: [libreoffice-users] The way SUM works

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).

That pretty well SUMs it up.  ;-)


--
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