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

2011/12/29 Johnny Rosenberg <gurus.knugum@gmail.com>:
> 2011/12/29 csanyipal <csanyipal@gmail.com>:
> > Jay,
> >
> >
> > Jay Lozier wrote
> > > On 12/29/2011 09:09 AM, csanyipal wrote:
> > >
> > > > I'm trying to figure out why differs AVERAGE calculations when using it
> > > > alone in a cell or when using it in a complex formula?
> > > >
> > > > http://nabble.documentfoundation.org/file/n3618892/Average_Problem.ods
> > > > Average_Problem.ods
> > > >
> > > > In the .ods abowe on the sheet '17.' one can see that that AVERAGE
> > > > calculations in the
> > > > 'AD30'
> > > > =IF(OR(COUNTIF(AD6:AD17;"=1");COUNTIF(AD19:AD20;"=1");COUNTIF(AD29;"=1"));"0";AVERAGE(AC6:AC17;AC19:AC20;AD29))
> > > >
> > > > and in the
> > > >
> > > > 'AD46'
> > > > =AVERAGE(AD6:AD17;AD19:AD20;AD29)
> > >
> > > One is (mostly) averaging the data in column AC and the other is using
> > > column AD. Since the data in each column is not the same the answers
> > > will be different.
> > >
> > > --
> > > Jay Lozier
> > > jslozier@
> > 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?
>
> Take a look again. They are still not the same (AD20 ≠ AD21).

Sorry for confusing. I mean that AD19:AD20 ≠ AD19:AD21. The first one
is two cells (4,5), the second one three (4,5,5).

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
>
> > -----
> > Best Regards from
> > Pál

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