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: [email protected] 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
