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

Jay Lozier wrote
> On 12/29/2011 12:38 PM, csanyipal wrote:
> > Johnny Rosenberg wrote
> > > 2011/12/29 csanyipal<csanyipal@>:
> > >
> > > > Jay Lozier wrote
> > > > > On 12/29/2011 09:09 AM, csanyipal wrote:
> > > > Indeed, I was inattentive here. Thanks!
>
> > > > 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.
> > > Take a look again. They are still not the same (AD20 ≠ AD21).
> >
> > Indeed, it seems that that I work to much and my attention abates. It's
> > time
> > to rest a little. Thanks for the support!
> I know these errors are often hard to properly track down. When I have 
> done something similar I knew I had entered the formula correctly but 
> had make a minor change with big results.
>
> One way to avoid this is to use named ranges. Say C2:C34 is named scores 
> then use the name in the formula.
Thank you very much for help!
(I want to thank you in private e-mail but this features doesn't work rigth
now.)

-----
Best Regards from
Pál
--
View this message in context: 
http://nabble.documentfoundation.org/AVERAGE-calculation-differs-when-alone-or-in-a-complex-formula-tp3618892p3620510.html
Sent from the Users mailing list archive at Nabble.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