[libreoffice-users] Re: AVERAGE calculation differs when alone or in a complex formula?

On 12/29/2011 09:07 AM, csanyipal wrote:
...
> Indeed, I was inattentive here. Thanks!
>
> http://nabble.documentfoundation.org/file/n3619267/Average_Problem.ods
> Average_Problem.ods 
>
> However, as one can see in the file abowe (that I upload again, modified of
> course) that AVERAGE still calculate slightly different when are used in
> complex formula as if it used alone.
>
> Eg. in the abowe file one can see on the '19.' sheet that cell 'AD30' with
> the same AVERAGE formula, that is in a complex formula calculate the value
> '4,07' but the cell 'AD46' calculate with the same AVERAGE formula when is
> alone the value '4,13'. How could that be?
...
Because they are not the same formula:
The AVERAGE portion of AD30 is:
AVERAGE($AD$6:$AD$17,$AD$19:$AD$20,$AD$29)
The AVERAGE portion of AD46 is:
=AVERAGE($AD$6:$AD$17,$AD$19:$AD$21,$AD$29)

Look carefully and you will see the difference.

If I change AD46 to:
AVERAGE($AD$6:$AD$17,$AD$19:$AD$20,$AD$29)
the result is the same as AD30




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