Hi, 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) cells are different. How could it be? ----- Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/AVERAGE-calculation-differs-when-alone-or-in-a-complex-formula-tp3618892p3618892.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
